[unixODBC-support] Trouble connecting to SQL Server database

Nick Gorham nick at easysoft.com
Thu Sep 9 18:38:57 BST 2004

Stephen wrote:

> Greetings,
> I've recently installed the unixODBC driver and FreeTDS provider in 
> Mandrake 10 using their default packages.  After configuring a SQL 
> Server database, and attempting to execute a query, I happily get back 
> the results.
> However, when I use isql to test the ODBC part of things, I get the 
> following error:
> [IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on 
> [ISQL]ERROR: Could not SQLConnect
> Now, the only fixes for this problem I've seen using google involve DB2 
> (setting the instance in the environment), and so I'm stumped as to what 
> I might need to do for a SQL Server database.  Any thoughts?

Normal reason is the lib you have pointed the driver= line in the ini 
isn't a ODBC driver, but some other lib.

Nick Gorham
Easysoft Limited

More information about the unixODBC-support mailing list