Skip to Content.
Sympa Menu

freetds - Re: Connect to Sybase ASE ?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Peter Moore <peter AT loved.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Connect to Sybase ASE ?
  • Date: Tue, 16 Oct 2001 18:46:05 +1000


i can verify that ASE 12 works using FreeTDS 0.52.
i connected from a BeOS PC and also from a Solaris 2.51 server.
ASE 12.0 was running on an ultra-sparc on Solaris 2.7

i didn't explicity configure it to use tds 4.2 - i just configured it as per
normal with the exception of the prefix flag which i set to my home
directory.
Be sure that the SYBASE environment variable is set. And yes SQSH is a very
good test of the install.
In fact i have a FreeTDS and SQSH bundle for BeOS which works very well.
cheers
peter
*******************************************
Peter Moore

peter AT loved.com
http://beos.loved.com/
ICQ 926967 (old) 95022055 (new - Oct 18, 2000)
*******************************************
>
>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.
>>
>
>
>---
>You are currently subscribed to freetds as: [peter AT loved.com]
>To unsubscribe, forward this message to leave-freetds-
>134510C AT franklin.oit.unc.edu
>





Archive powered by MHonArc 2.6.24.

Top of Page