Verifying that you can Connect to Microsoft SQL Server

Verify the connection to the replicate Microsoft SQL Server database.

1. Open a command window in the %SYBASE% directory of your ECDA installation.
2. Change to the %SYBASE%\DC-15_0 directory.
3. Set the environment variables by sourcing the %SYBASE%\DC_SYBASE.bat file.
4. Log in to Microsoft SQL Server through the DirectConnect service:

   isql –Uvaliduser –Ppassword –Smy_mssql_access_service

   where validuser and password are any valid user and password, and my_mssql_access_service is the DirectConnect service name.

5. Verify the connection to the replicate Microsoft SQL Server database by obtaining the DBMS name and version number:

   select @@sqldbmsname

   go

   SQLDbmsName

   ---------------------

   Microsoft SQL Server

   select @@sqldbmsver

   go

   SQLDbmsVer

   ---------------------

   09.00.1399

6. Exit the isql session with the quit command.