Configure the ODBC driver to connect to the replicate
database.
The ODBC driver is installed with the installation of Microsoft SQL Server.
Note: If you already have a data source configured for your replicate
database, skip to "Configure and Start the DirectConnect Server."
Open the ODBC Driver Manager by navigating
to Control Panel > Administrative Tools and double-clicking
the Data Sources (ODBC) icon.
Click the Drivers tab, and verify that the Microsoft
SQL Server driver is version 2000.86.1830.00. If it is an earlier
version, go to the Microsoft Web site to download and install the
correct version.
Click the System DSN tab, click Add, and select
the Microsoft SQL Server driver. Click Finish.
In the Name field, enter a name that identifies
your replicate data server and database, for example, my_mssql_datasource_name.
Use this name later when you configure the ECDA access service.
Select the replicate Microsoft SQL Server in the Server drop-down
list. Click Next.
Be sure that Microsoft SQL Server authentication
is selected, and the Connect to Microsoft SQL Server check box is
checked. Enter a valid Microsoft SQL Server login ID and password,
and click Next.
Select Change the Default Database To, and select
the replicate database from the drop-down list. Click Next.
Click Finish.
Verify ODBC connectivity to the replicate database
by clicking Test Data Source. If connectivity is not successful,
verify that you have configured the ODBC driver correctly.
Click OK.
You should now see your Microsoft SQL Server data
source in the list of System Data Sources. Click OK.