Hi,
I am trying to create a asaodbc connection in IQ to connect from a
12.7 IQ server to another 12.7 remote IQ server on solaris platform. I
have dsn defined for the remote iq server and fire the following sql
commands:

1> create server remoteiq class 'aseodbc' using 'IQSRV2'
2> go
1> create externlogin DBA to remoteiq remote login DBA identified by SQL
2> go
1> forward to remoteiq
2> go
(return status = 0)
1> select @@servername
2> go
Msg 11206, Level 16, State 0:
ASA Error -656: Unable to connect to server 'remoteiq': [Sybase][ODBC
Driver
Loader] Data source not found and no default driver specified
1> quit

The $ODBCINI points to the .odbc.ini file which has the dsn IQSRV2
defined. I also tried to directly connect to IQSRV2 using the ODBC dsn
defined and it works fine. What could be the problem here? Is it that
the server is internally looking for a different dsn source?

Regards,

Nandan,

1. This is a SQL Anywhere-specific newsgroup. IQ questions should be
posted to sybase.public.iq.

2. The "USING" clause for remote servers usually specifies a complete
connection string, with the driver also specified on UNIX if necessary:

See:
http://dcx.sybase.com/1101en/dbusage...mni-using.html

CREATE SERVER RemoteASE
CLASS 'ASEODBC'
USING
'/opt/sybase/ase_odbc_1500/DataAccess/ODBC/lib/libsybdrvodb.so;dsn=IQSRV2';

Regards,

Nandan Marathe wrote:
--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/