FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Ross Simpson [mailto:mqsimpson AT aol.com]
> Sent: September 13, 2002 11:41 AM
> To: TDS Development Group
> Subject: [freetds] help: tsql cannot connect to db while isql can
> 
> I'm trying to get FreeTDS to talk to a Sybase 12.5 db, with no luck.
...
> I have no freetds.conf file, and the interfaces file looks like this
> (the correct addresses are present in the file):
>       EMDEV125_SYB
>               master tcp ether address.here 3106
>               query tcp ether address.here 3106
> 
> SQL Server version:   Sybase ASE 12.5
> FreeTDS version:      0.60, built with protocol version 7.
                                               ^^^^^^^^^

FreeTDS is using TDS 7.0 to try to connect to a Sybase server.  Is no good,
Ross.  

export TDSVER=5.0 # or whatever your shell requires

and enjoy.  If you have to be able to connect to Microsoft databases, too,
there are more steps to take.  

Regards and welcome, 

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that for certain accounts we do not accept
orders and/or instructions by e-mail, and for those accounts we will not be
responsible for carrying out such orders and/or instructions. Kindly refrain
from sending orders or instructions by e-mail unless you have confirmed that
we accept such communications for your account. Please also note that to
satisfy regulatory requirements we review the outgoing and incoming e-mail
correspondence of staff members serving certain functions.