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

Nick Gorham nick.gorham at easysoft.com
Fri May 7 10:33:10 BST 2010


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.

-- 
Nick



More information about the unixODBC-support mailing list