If you already have a data source configured for your replicate database, skip to “Configuring and starting the DirectConnect server”.
When you installed Microsoft SQL Server, an ODBC driver was also installed. Configure this driver to connect to the replicate database.
Configuring the Microsoft SQL Server ODBC driver
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.
