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

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


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.

-- 
Nick


More information about the unixODBC-support mailing list