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

[Nick Gorham]

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