FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

If you are going after a SQL 7.0 database you need to be using at least
0.46 (and preferably one of the recent snapshots as there have been alot
of bug fixes this past week). 0.45 had some bugs that SQL Server 7
tickled. (I should really put this in the FAQ...)

Possibility #2 would be that you are configured to use TDS 5.0 which will
not work on Microsoft servers.  Make sure to 'configure --with-tdsver=4.2'

If that isn't the problem see if you can compile and run SQSH 1.7 and post
back. (There are some instructions in the freetds FAQ on compiling it with
freetds)

Cheers,

Brian

On Tue, 31 Aug 1999, Francis Smit wrote:

> Hi again sorry to bother you all again, But I am still stuck, I can
> connect to the JDBC database, but not to our own MS-SQL DB
> here at work, which version should I be using for this by the way??
> perhaps thats part of my problem.
> 
> Brian Bruns wrote:
> 
> > You probably need to include any additional directories where .so
> > libraries are in the LD_LIBRARY_PATH as well...As for why it worked one
> > time and not the other...good question.
> >
> > On Thu, 26 Aug 1999, Francis Smit wrote:
> >
> > > Wow!!!! now it all works; thanks for all that help
> > > Brian, I wonder why it suddenly started???
> > >
> > > Francis Smit wrote:
> > >
> > > > Oh I forgot to say my page still doesn't work either
> > > > but those vars come up set, i.e. I still cannot connect
> > > > to JDBC
> > > >
> > > > Francis Smit wrote:
> > > >
> > > > > Thanks for all the help but I still need more help :-(#
> > > > > I inserted the following two lines into httpd.conf:
> > > > >
> > > > > SetEnv SYBASE /usr/local/freetds
> > > > > SetEnv LD_LIBRARY_PATH /usr/local/freetds/lib
> > > > >
> > > > > but as soon as I did I could no longer restart the server,
> > > > > I now get a error message:
> > > > >
> > > > > [root@mug init.d]# !./
> > > > > ./httpd start
> > > > > Starting httpd:
> > > > > Syntax error on line 70 of /etc/httpd/conf/httpd.conf:
> > > > > Cannot load /etc/httpd/modules/libphp3.so into server: 
> > > > > /etc/httpd/modules/libphp3.so:
> > > > > undefined symbol: dbdead
> > > > >
> > > > > [FAILED]
> > > > > [root@mug init.d]# ./httpd restart
> > > > > Shutting down
> > > > > http:
> > > > > [FAILED]
> > > > > Starting httpd:
> > > > > Syntax error on line 70 of /etc/httpd/conf/httpd.conf:
> > > > > Cannot load /etc/httpd/modules/libphp3.so into server: 
> > > > > /etc/httpd/modules/libphp3.so:
> > > > > undefined symbol: dbdead
> > > > >
> > > > > [FAILED]
> > > > >
> > > > > I tried deleting this and it work again, I've move it around the 
> > > > > file
> > > > > no good? and now the server will not restart;
> > > > > but if  I reboot the system it starts again, but will not restart.
> > > > >
> > > > > Brian Bruns wrote:
> > > > >
> > > > > > You can put it in httpd.conf and restart apache (at least the 
> > > > > > SYBASE
> > > > > > variable).  The exact command escapes me at the moment but its 
> > > > > > something
> > > > > > like SetEnv I think.
> > > > > >
> > > > >
> > > > > --
> > > > > Francis Smit
> > > > >
> > > > > Knowledge By Design/OzTel
> > > > > Suite 201, 683 George st
> > > > > Sydney 2000 NSW
> > > > >
> > > > > mailto:francis AT kbd.com.au
> > > > >
> > > > > Tel: +61 2 9212 1399
> > > > > Fax: +61 2 9212 5727
> > > > > ___________________________________
> > > > > m$: How can we stuff you up today?
> > > > >
> > > > > ---
> > > > > You are currently subscribed to freetds as: grisly AT kbdnet.net.au
> > > > > To unsubscribe, forward this message to $subst('Email.Unsub')
> > > >
> > > > --
> > > > Francis Smit
> > > >
> > > > Knowledge By Design/OzTel
> > > > Suite 201, 683 George st
> > > > Sydney 2000 NSW
> > > >
> > > > mailto:francis AT kbd.com.au
> > > >
> > > > Tel: +61 2 9212 1399
> > > > Fax: +61 2 9212 5727
> > > > ___________________________________
> > > > m$: How can we stuff you up today?
> > > >
> > > > ---
> > > > You are currently subscribed to freetds as: grisly AT kbdnet.net.au
> > > > To unsubscribe, forward this message to $subst('Email.Unsub')
> > >
> > > --
> > > Francis Smit
> > >
> > >
> > > Knowledge By Design/OzTel
> > > Suite 201, 683 George st
> > > Sydney 2000 NSW
> > >
> > > mailto:francis AT kbd.com.au
> > >
> > > Tel: +61 2 9212 1399
> > > Fax: +61 2 9212 5727
> > > ___________________________________
> > > m$: How can we stuff you up today?
> > >
> > >
> > >
> > > ---
> > > You are currently subscribed to freetds as: camber AT ais.org
> > > To unsubscribe, forward this message to $subst('Email.Unsub')
> > >
> > >
> >
> > ---
> > You are currently subscribed to freetds as: grisly AT kbdnet.net.au
> > To unsubscribe, forward this message to $subst('Email.Unsub')
> 
> --
> Francis Smit
> 
> 
> Knowledge By Design/OzTel
> Suite 201, 683 George st
> Sydney 2000 NSW
> 
> mailto:francis AT kbd.com.au
> 
> Tel: +61 2 9212 1399
> Fax: +61 2 9212 5727
> ___________________________________
> m$: How can we stuff you up today?
> 
> 
> 
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>