freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] Issue with Connecting to MS SQL,
Oswin Dsa, 04/05/2016
- Re: [freetds] Issue with Connecting to MS SQL, Frediano Ziglio, 04/15/2016
Archive powered by MHonArc 2.6.24.