[unixODBC-support] DB2, Driver's SQLAllocHandle on SQL_HANDLE_HENV

Chunmei Wu chunmei.wu at oracle.com
Sat May 8 04:26:52 BST 2010

Hi Nick and Martin,

Seems that the db2 is not installed correctly. After reinstalling it, the isql can work with DB2. Thank you very much!

Chunmei Wu

-----Original Message-----
From: Nick Gorham [mailto:nick.gorham at easysoft.com] 
Sent: 2010年5月7日 17:33
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] DB2, Driver's SQLAllocHandle on SQL_HANDLE_HENV

Nick Gorham wrote:
> Chunmei Wu wrote:
>> Hi Nick,
>> After setting this environment:
>>             unixuser\@dsliaa05 # > env|grep DB2INSTANCE
>>             DB2INSTANCE=unixuser
>> The error is changed which is not 'Driver's SQLAllocHandle on 
>> SQL_HANDLE_HENV' error:
>>     unixuser\@dsliaa05 # > ./isql -v Q10F qadmin qadmin
>>     [IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on 
>> SQL_HANDLE_DBC failed
>>     [ISQL]ERROR: Could not SQLConnect
>> I can connect this DB using db2:
>>     unixuser\@dsliaa05 # > db2 connect to Q10F user QADMIN using QADMIN
>>        Database Connection Information
>>      Database server        = DB2 z/OS 9.1.5
>>      SQL authorization ID   = QADMIN
>>      Local database alias   = Q10F
>> Following is the definition of Q10F in odbc.ini
>>     [Q10F]
>>     ServerName=Q10F
>>     Driver=/opt/IBM/db2/V9.7/lib64/db2o.o
>> Thanks,
>> Chunmei Wu
> Well, its a db2 issue, but in the past the instance was normally the 
> same as the dsn. What happens if you set DB2INSTANCE to Q10F
> Also if that makes no difference, try reverting to the default 
> SQLHANDLE definition you had before.

Well, then try the previous handle definition. Shame you didnt try the 
instance when Martin first suggested it.


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

More information about the unixODBC-support mailing list