Update ODBC Connection

Updating ODBC Connection to Use Live Database

If you originally setup UPS WorldShip to work with your practice company then you will need to follow these steps to update the ODBC connection to work with your live company.

1.   Select Start Menu > Control Panel > Administrative Tools > Data Sources (ODBC). The ODBC Data Source Administration window will open.

Click on the System DSN tab. Highlight the ACCTivateCompany you created previously select ‘Configure’

configodbc

2.   The Microsoft SQL Server DSN Configuration window will pop-up. Click Next to continue with the process.

3. Enter the password.

The Microsoft SQL Server administrator login is sa (i.e., System Admin).  The password may have been changed during the installation or configuration of SQL Server. Please contact the Acctivate support team or your database or network administrator for credentials for the database. .

Click the Next button

4.   Select ACCTivate$CompanyName for the live company from the drop-down menu. This database name is the live database that stores your Acctivate data on the server.

ACCTivatecompanyname

If this is not available, please consult with your network or database administrator. Keep the other defaults and click the Next button.

5.   The settings on this window should not need to be changed. Simply click the Finish button and a window titled ODBC Microsoft SQL Server Setup will pop-up.

6.   Quickly review the information on the ODBC Microsoft SQL Server Setup window. You may test the connection by clicking the Test Data Source button.

When you are certain that the information is correct, click the OK button.

DataSourceTest

7.   The pop-up windows will close and you will be back at the main ODBC Data Source Administrator window.

Click OK. The ODBC Microsoft SQL Server Setup window will close.

Posted in Database - Last modified on September 10, 2015Cassandra Creasy
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.