[freetds] Problems Connecting Debian --> MSSQL through odbc

jklowden at schemamania.org jklowden at schemamania.org
Tue Jul 14 11:31:33 EDT 2009


On Tue, Jul 14, 2009 at 05:21:12PM +0200, Jaap van Arragon wrote:
> 
> I had multiple freetds.conf files.
> 
> I've found the right one and I can now connect through tsql.
> 
> BUT I can't connect through isql.
> 
> SERVER:# isql -v TEST -w
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [ISQL]ERROR: Could not SQLConnect

What does src/apps/osql report?  TDSDUMP?  

Are you sure TEST is configured correctly in odbc.ini?  

Likely problems:

1.  two odbc.ini files, or one where unixODBC is not looking. 
2.  using servername instead of server or vice-versa. 
3.  leaving TDS_Version out of the odbc.ini section. 
4.  misidentifying the driver in odbc.ini. 

--jkl


More information about the FreeTDS mailing list