ODBC Setup Guide

Shannon Obanion Updated by Shannon Obanion

ODBC Setup Guide

Prerequisites:

  1. PioneerRx SQL ShippingUser and Password
  • This information is visible in PioneerRx under the Help Icon > Workstation Information.

Setup Instructions:

  1. On the computer that will have the shipping software installed.
  2. Click the Windows Start button and type in ODBC. Launch the ODBC Data Sources (32-Bit) App.

 

  1. Locate the System DNS tab and click Add, select SQL Server:

  1. Type in PioneerRx Shipping as the name and description input boxes.
  2. For the SQL Server input box type in your server's host name followed by \newtech.
  • Example: PioneerServer\newtech
  • To verify your location's server hostname, launch PioneerRx and select the help arrow and select Workstation Information.
  • Your server's hostname and your ShippingUser and Password will  be displayed.

 

  1. Click Next >
  2. Select the radio button next to: With SQL Server authentication using a Login ID and Password entered by the user.
  3. Input the ShippingUser username and the ShippingUser password.

 

  1. Click Next >
  2. Check the box next to Change the default database to: Select PioneerPharmacySystem from the drop down.
  3. Click Next >

  1. Click Finish >
  2. Click Test Data Sources… A Test Results Box should show TESTS COMPLETED SUCCESSFULLY!

 

 

 

This completes the  ODBC Setup Guide.

You can now continue setting up your Shipping Software

How did we do?

FedEx Shipmanager Install and Setup

UPS Worldship Install and Integration Setup

Contact