FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

SQSH is written by Scott Gray and can be downloaded from:

http://www.users.voicenet.com/~gray/sqsh.html

Brian

On Mon, 15 Oct 2001, Norman Palardy wrote:

> Is SQSH part of the download ?
> I can't locate it anywhere on my machine after the config and makes
> 
> On Monday, October 15, 2001, at 06:15  PM, Brian Bruns wrote:
> 
> >
> > 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.
>