Connecting to Sybase without setting DSQUERY.
kevinbOct 3 2011 — edited Jul 24 2013I'm having problems connecting to a Sybase instance without setting the DSQUERY environment variable. I've heard that DSQUERY isn't required and the docs seem to say the same thing, but I can't get it to work. Has anyone encountered this before?
Kevin
Below I'm illustrating the problem by using DBLOGIN. The problem is the same when trying to start a REPLICAT.
There is an entry for the server in the interfaces file. isql works, etc.
-----------------------------------------
[oracle@hostA gg]$ ggsci
Oracle GoldenGate Command Interpreter for Sybase
Version 11.1.1.0.1 Build 004
Linux, x64, 64bit (optimized), Sybase 15.0 on Aug 31 2010 20:27:53
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI (hostA.domain.com) 1> dblogin sourcedb db01, userid myuser@syb000
Password:
ERROR: Cannot connect to database db01 at server syb000.
Client Library error: severity(0) number (44) origin(1) layer(4).
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
GGSCI (hostA.domain.com) 2> exit
[oracle@hostA gg]$ export DSQUERY=syb000
[oracle@hostA gg]$ ggsci
Oracle GoldenGate Command Interpreter for Sybase
Version 11.1.1.0.1 Build 004
Linux, x64, 64bit (optimized), Sybase 15.0 on Aug 31 2010 20:27:53
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI (hostA.domain.com) 1> dblogin sourcedb db01, userid myuser
Password:
Successfully logged into database.
GGSCI (hostA.domain.com) 2>