Skip to Content.
Sympa Menu

freetds - [freetds] Freetds connection problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Franck Y" <franck110 AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Freetds connection problem
  • Date: Fri, 21 Nov 2008 12:32:33 -0500

Hello Guys,

I am really totally lost with Freetds.

I will resume what is did.

First i am running SQL server 2005.

1) i did a telnet 1433 on my server and it work correclty so my
problem is not a firewall related problem.

2)In SQL server 2005 the server name is "MYSERVER\SL"

I created a file under /etc/freetds.conf

like this

-----
[MS1]
host = 192.168.10.50
port = 1433
tds version = 7.0


[MS2]
host = 192.168.10.50
port = 1433
tds version = 8.0


[MS3]
host = 192.168.10.50\SL
port = 1433
tds version = 7.0


[MS4]
host = 192.168.10.50\SL
port = 1433
tds version = 8.0


[MS5]
host = 192.168.10.50\sl
port = 1433
tds version = 7.0


[MS6]
host = 192.168.10.50\sl
port = 1433
tds version = 8.0
-----

i have tried every connection like this
tsql -S MSSQL5 -U sa
etc...
everytimes i got
There was a problem connecting to the server
Any hints ??


Thanks for you precious help !


Franck




Archive powered by MHonArc 2.6.24.

Top of Page