[unixODBC-support] domain login fails in isql but works with tsql

Eric Robinson (erirobin) erirobin at cisco.com
Thu Apr 15 22:04:06 BST 2010

So UNIXodbc and FreeTDS both are working fine now :)

My end goal was to use Oracle DG4ODBC -> UNIXodbc -> FreeTDS to access
MSSQL from Oracle using a domain\userid and that is working fine.

Apparently there is a bug in the isql on the box I am on and I wrongly
assumed it was provided by UNIXodbc (my bad). It is not associated with
any RPM so I have no clue what installed it, probably provided by

Thanks again for your responses,


-----Original Message-----
From: Eric Robinson (erirobin) 
Sent: Thursday, April 15, 2010 10:16 AM
To: 'Support for the unixODBC project'
Subject: RE: [unixODBC-support] domain login fails in isql but works
with tsql

Ok, thanks.. I will follow up with them also.

I appreciate the feedback.

-----Original Message-----
From: unixodbc-support-bounces at mailman.unixodbc.org
[mailto:unixodbc-support-bounces at mailman.unixodbc.org] On Behalf Of Nick
Sent: Thursday, April 15, 2010 10:13 AM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] domain login fails in isql but works
with tsql

Eric Robinson (erirobin) wrote:
> Nick, 
> I don't feel there is any issue with FreeTDS and the connection works
> different ways(albeit all provided by FreeTDS):
Ok, with respect, you are free to have that feeling.
> 1) Bypassing freetds.conf via tsql and connecting directly to the db
> host like this:
> 	tsql -H <physical db host> -p 1433 -U <domain/userid>
> 2) Using tsql via the settings in freetds.conf
> 	tsql -S <freetds.conf entry> -p 1433 -U <domain/userid>
> 3) Using fisql via the settings in freetds.conf
> 	fisql -S <freetds.conf entry> -U <domain/userid>
> All of which are provided by freetds.
> I only get errors when accessing via UNIXodbc manager.

No, you only have that error when accessing via ODBC from what I can

The error you reported:

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

Shows clearly that the driver manager has located and loaded the FreeTDS

driver, and has passed the connection request to it, the error is 
returned to the driver manager from the driver.

unixODBC-support mailing list
unixODBC-support at mailman.unixodbc.org

More information about the unixODBC-support mailing list