FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

This set up should work fine.  Have you tried SQSH to make sure
your FreeTDS installation is working properly?  If sqsh works, we can look
at your code a bit more closely, if not we have a configuration problem
(or bug) of some sort.

11.9.2 is the newest server I've connected to, but while not positive it
works, I'd be (very) surprised if it didn't.

Brian

On Mon, 15 Oct 2001, Norman Palardy wrote:

> 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.
>