Connect to Sybase ASE ?
Norman Palardy
norm at kirais.com
Mon Oct 15 16:29:27 EDT 2001
Just trying to use freetds based on what I've gleaned from the list and
various members who have helped out with private e-mails
But I can't get it to connect to Sybase ASE 12
I grabbed the freetds-current.tgz distribution from
http://www.freetds.org/download.html
Compiled with
./configure --prefix=/usr/local/freetds --with-tdsver=4.2
--enable-dbmfix --enable-shared --enable-static
make
make check
make install
edited /usr/local/freetds/interfaces to add the servers I wanted to
connect to (they are correct entries)
renamed /usr/local/freetds/etc/freetds.conf
/usr/local/freetds/etc/freetds.conf_old
the program simply tries to connect and check whether the login
succeeded or failed so I can essentially make a sybase pinger
But, the following ALWAYS says the connection failed regardless. I
always get the NOT Connected message printing out
I can connect to the exact same SQL server using JDBC from the same
client so I know the connection works.
printf("Attempt to connect to %s\n", argv[1]) ;
dbproc = dbopen( login , argv[1] ) ;
if ( dbproc == NULL )
printf("NOT connected\n") ;
else
printf("connected\n") ;
return retCode ;
Login is NOT null. And, the error & message handlers that I've defined
do not get called.
Is freetds not functionally the same as dblib ?
I know this bit of code works with Sybase' libraries on Solaris for
versions 1192 and 1200.
More information about the FreeTDS
mailing list