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 running the %SYBASE%\DC_SYBASE.bat file.
4. Log in to the replicate database through the DirectConnect service:

   isql –Uvaliduser –Ppassword –SDCService

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

5. Verify the connection to the replicate database:
   

   select @@sqldbmsname
   go
   SQLDbmsName
   ---------------------
   Microsoft SQL Server
   
   select @@sqldbmsver
   go
   SQLDbmsVer
   ---------------------
   09.00.1399

6. Exit the isql session with the quit command.