<html><body>
<p>Hi Folks,<br>
<br>
I'm wondering if somebody could help shed some light. I'm trying to use unixODBC (unixODBC-2.2.11-21.4) to connect to a DB2 database; however, I am getting the following error.<br>
<br>
linuxvm2:/home/db2inst1 # isql -v GSMRTHST fpani0 <password><br>
[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed<br>
[ISQL]ERROR: Could not SQLConnect<br>
<br>
I can confirm that I can connect to the DB2 database no problem from command line and have followed instructions for DB2 posted on the unixODBC site, but to no previal. In other newsgroups postings, I see issues between 32 and 64 bit versions; however I can confirm that I am using 64 bit of DB2 and unixODBC.<br>
<br>
My very simple ini files follow. Could somebody suggest some things to check? Once I get this working, I'll happy to make suggested changes to the documentation on unixODBC. Thanks.
<p>/etc/odbc.ini --><br>
[GSMRTHST]<br>
Description = IBM DB2 ODBC DRIVER<br>
Driver = DB2<br>
<br>
odbcinst.ini --><br>
[DB2]<br>
Description = IBM DB2 ODBC DRIVER<br>
Driver = /home/db2inst1/sqllib/lib/libdb2.so<br>
FileUsage = 1<br>
DontDLClose = 1<br>
UsageCount = 4<br>
<br>
[ODBC]<br>
Trace = yes<br>
Tracefile = /tmp/odbctrace.log<br>
UsageCount = 4</body></html>