FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Osman Çinar Eren [mailto:Cinar.Eren AT isbank.com.tr] 
> Sent: Wednesday, October 16, 2002 3:06 AM
> 
> my .freetds.conf has the following entry:
> 
> [TESTC]
>         host = 10.50.104.133
>         port = 1433
>         tds version = 7.0
> 
> when i try to use the unittest, i get the following error:
> 
> connection parameters:
> server:   'TESTC'
> user:     'cinar'
> password: '????'
> database: 'cinar'
> Unable to open data source (ret=-1)
> SQL error 08001 -- [unixODBC]tds_connect failed
> FAIL: t0001
> ===================
> 1 of 1 tests failed
> ===================
> 
> I had a look at the debug file; /tmp/freetds.log and realized 
> that although
> TESTC is set to be '10.50.104.133', unittest tries to connect 
> to localhost.

Cinar, 

One of three things is true:

1. There is an error in the unixODBC or FreeTDS files.  
2. unixODBC is not reading the INI you think it is.
3. FreeTDS is not reading the freetds.conf you think it is. 

I suggest you use the TDSDUMPCONFIG environment variable to ask FreeTDS to
log its attempt to locate your server in its configuration files.  I think
that log will answer your questions.  If not, post it here.  

FreeTDS won't attempt to connect to localhost unless explicitly requested.
(localhost is not a default fallback of any kind.)  I suspect an ODBC
misconfiguration.  

HTH.

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.