1. Direct connect is installed on the rep server.
2. I have configured an ODBC connection for the MS SQL 2000
database server.
3. I have added the server to sql.ini file for both the
Direct Connect Server and DirectConnect Access Server.
4. The DirectConnect Access Server was created successfully.
I can connect and query the MS SQL Database using both the
SQL Access Tool and isql.
5. The Heterogeneous Data Source scripts have been run:
hds_msss_funcstrings.sql against the RSSD database and
hds_msss_setup_for_replicate.sql and I've granted
permissions to the new objects loaded as part of
hds_msss_setup_for_replicate.sql to the connection account
"directcon".
6. Sybase Open Client has been installed on the MS SQL
Server and I've added the sql.ini contains entries for the
rep server and rssd database server instance and can
successfully ping both.
7. MDAC on the Rep Server is at: 2.61.7326.0 and on the MS
SQL Server its at: 2.82.1830.0
Here's the problem:
When I go to create the connection using the following:
create connection to DUBISQLQA01.saleq
set error class rs_sqlserver_error_class
set function string class rs_msss_function_class
set username directcon
set password Password2
go
I get the following error:
I. 2007/06/25 22:01:12. SQM starting: 215:0
DUBISQLQA01.saleq
I. 2007/06/25 22:01:12. The DSI thread for database
'DUBISQLQA01.saleq' is started.
E. 2007/06/25 22:01:13. ERROR #8025 DIST(101
JRMSYBP2.JRMREPP1_RSSD) - (463)
Database 124 is unknown.
I. 2007/06/25 22:01:13. Skipping command: <A0110
05cp850distribute 1 ~";Jun 25 2007 10:01:11:850PM,2 ~"!,3 1
begin transaction ~".ConnectionDDL for ~"3JRMREPP1_RSSD_prim
>
E. 2007/06/25 22:01:13. ERROR #8025 DIST(101
JRMSYBP2.JRMREPP1_RSSD) - (463)
Database 124 is unknown.
I. 2007/06/25 22:01:13. Skipping command: <A0110
05cp850distribute 2 ~"!,3 1 applied
~!-rs_databases.~!*rs_insert yielding after
~$'dsname=~",DUBISQLQA01, ~$'dbname=~"&saleq,
~$Ûid=215, ~$,dist_status=1, ~$+src_status=0,
~$+attributes=0, ~$-errorclassid=0x0000000001000002,
~$,funcclassid=0x0000000001000011, ~$&prsid=16777317,
~$(rowtype=1, ~$-sorto_status=0, ~$<ype=~""P,
~$&ptype=~""A, ~$&ldbid=215, ~$+enable_seq=0 >
E. 2007/06/25 22:01:13. ERROR #8025 DIST(101
JRMSYBP2.JRMREPP1_RSSD) - (463)
Database 124 is unknown.
I. 2007/06/25 22:01:13. Skipping command: <A0110
05cp850distribute 1 ~";Jun 25 2007 10:01:11:850PM,2 ~"!,3 1
commit transaction >
E. 2007/06/25 22:01:14. ERROR #1028 DSI(215
DUBISQLQA01.saleq) - (1995)
Message from server: Message: 30291, State 0, Severity 19
-- '[VENDORLIB] Vendor Library Error: [[Message
Iteration=1|Data Source
Name=DUBISQLQA01|SQLState=42000|Native
Error=170|Message=[Microsoft][ODBC SQL Server
Driver][SQL Server]Line 1: Incorrect syntax near '\'.]
<DCA>'.
E. 2007/06/25 22:01:14. ERROR #5046 DSI(215
DUBISQLQA01.saleq) - (2009)
When executing the rs_get_lastcommit function in database
'DUBISQLQA01.saleq', received data server errors. See logged
data server errors for more information.
I. 2007/06/25 22:01:14. The DSI thread for database
'DUBISQLQA01.saleq' is shutdown.
Can someone please help me to resolve this error?
Thanks!