To verify the ECDA installed objects
Open another command window and navigate to the DirectConnect installation. For example:
cd c:\sybase\DC-15_0
Set the environment variables by executing the DC_SYBASE.bat file.
Use the Sybase isql utility to log in to the replicate Microsoft SQL Server database through ECDA as maintuser.
To verify whether the rs_info table has been created successfully:
isql –Umaintuser –Ppassword -Smy_mssql_access_service select * from rs_info go
This following result is returned:
RSKEY RSVAL -------------------- ---------------- charset_name cp850 sortorder_name bin_cp850 (2 rows affected)
To verify whether the rs_lastcommit table has been created successfully:
isql –Umaintuser –Ppassword –Smy_mssql_access_service select * from rs_lastcommit go
The following is result is returned:
ORIGIN ORIGIN_QID SECONDARY_QID ORIGIN_TIME DEST_COMMIT_TIME
-------------------- -------------------
-------------------- ------------------ (0 rows affected)
If the ECDA objects are not installed successfully, no results are displayed, and you encounter an error message.
Exit the isql session with the quit command.
