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 standby Microsoft SQL Server database through ECDA as maintuser.
To verify whether the rs_info table has been created successfully:
isql –Umaintuser –Ppassword -Smy_standby_mssql_service select * from rs_info go
This following result is returned:
rskey rsval -------------------- ---------------- charset_name iso_1 sortorder_name bin_iso_1 (2 rows affected)
To verify whether the rs_lastcommit table has been created successfully:
isql –Umaintuser –Ppassword –Smy_standby_mssql_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.
