Skip to Content.
Sympa Menu

freetds - RE: [freetds] MS SQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Akshay Rao <Akshay AT crc.ufl.edu>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] MS SQL Server 2000
  • Date: Thu, 27 Feb 2003 10:38:35 -0500

So I assume that my freetds.conf file should look something like this:

[SQL2K]
host = XXX.XXX.XXX.XXX
port = XXXX
tds = 8.0

Is that correct? I also read about some options such as "try domain login",
"try server login", "nt domain", and "emulate little endian". Should I be
concerned with these options?

-avrao

-----Original Message-----
From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
Sent: Wednesday, February 26, 2003 2:01 PM
To: 'FreeTDS Development Group'
Subject: RE: [freetds] MS SQL Server 2000


> From: Akshay Rao [mailto:Akshay AT crc.ufl.edu]
> Sent: February 26, 2003 11:06 AM
> To: 'freetds AT lists.ibiblio.org'
> Subject: [freetds] MS SQL Server 2000
>
>
> I have a linux box with Apache+PHP (latest of both) and
> Freetds 0.61. I also
> have a remote SQL 2000 Server that I need to connect to. Here is the
> problem: When I try to connect to a remote SQL 7.0 Server
> with the 7.0 TDS
> protocol, it works just fine. However when I try to use the
> 7.0 protocol to
> connect to SQL 2000, it says that the connection couldn't be
> made. When
> using the 8.0 protocol, I can't connect to SQL 7.0 or 2000.
> I think my
> problem lies with the instance name of the SQL 2000 Server. How do I
> specify the instance to FreeTDS? Also, when I use the tsql
> the following is
> my output:
>
> Msg 10019, Level 9, State 0, Server OpenClient, Line 0
> Server xxx.xxx.xxx.xxx not found!
> There was a problem connecting to the server

We haven't worked out the discovery protocol for named instances in SQL
Server 2000. You have to know the port number you're connecting to, and
specify them individually in freetds.conf.

TDS 8.0 won't connect to SQL Server 7.0.

Does that answer your questions?

--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 we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page