Re: Issue with Connecting to MS SQL

2016-04-05 8:16 GMT+01:00 Oswin Dsa <[email protected]>:
> 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