Skip to Content.
Sympa Menu

freetds - [freetds] Issue with Connecting to MS SQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Oswin Dsa <Oswin.Dsa AT mindtree.com>
  • To: "FreeTDS AT lists.ibiblio.org" <FreeTDS AT lists.ibiblio.org>
  • Subject: [freetds] Issue with Connecting to MS SQL
  • Date: Tue, 5 Apr 2016 07:16:31 +0000

Hello,

I tried to make changes in DB connection string so that values are picked
from FreeTDS.conf file as follows,

DB Connection string =
Driver=/Applications/xxx.app/Contents/Frameworks/libtdsodbc.so;Servername=ABC;DATABASE=DB;uid=username;pwd=*****;Trusted_Connection=No;

FreeTDS.conf (/usr/local/etc) content :

[ABC]
Host = xxx.xx.xx.xx
Port = 1433
tds version = 7.3
dump file =/tmp/freetds.log
debug flag = 0xffff
client charset = UTF-8

I changed the value of tds version(from 8.0 to 7.3.) after going through
FreeTDS user guide .

Now the error has changed to ,
[01000] [FreeTDS][SQL Server]Unknown host machine name. (20013)
[08001] [FreeTDS][SQL Server]Unable to connect to data source (0)

The freetds.log is also not being generated. So I have no clue what's going
wrong and where.

Could someone point me in the right direction ?

Regards,
Oswin



________________________________

http://www.mindtree.com/email/disclaimer.html




Archive powered by MHonArc 2.6.24.

Top of Page