Skip to Content.
Sympa Menu

freetds - Re: [freetds] Issue with Connecting to MS SQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Issue with Connecting to MS SQL
  • Date: Fri, 15 Apr 2016 16:04:56 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page