[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] Issue with Connecting to MS SQL
From:       Frediano Ziglio <freddy77 () gmail ! com>
Date:       2016-04-15 15:04:56
Message-ID: CAHt6W4e=DJpqGyiFB8oXGGdaOW5MYVS0b0y11BRDr8PaSUjNig () mail ! gmail ! com
[Download RAW message or body]

2016-04-05 8:16 GMT+01:00 Oswin Dsa <Oswin.Dsa@mindtree.com>:
> 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
> 


Try to use TDSDUMPCONFIG environment. Could be that is not picking up
your freetds.conf file for some reason.
Are you sure that server port is 1433 and open?

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


[prev in list] [next in list] [prev in thread] [next in thread]