How do I update an ODBC connection?

Open the ODBC Data Source window, select your Acctivate connection under the System DSN tab, then click on Configure. Go through the setup while entering your current database information.

Updating ODBC Connection to Use Live Database

If you originally setup a shipping workstation such as UPS Worldship to work with your 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 DSNtab. Highlight the AcctivateCompany you created previously select ‘Configure’

configodbc

2.   The Microsoft SQL Server DSN Configurationwindow 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.