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

[Chunmei Wu]

Hi Nick,

If I set the DB2INSTANCE to Q10F, I can't connect the db using db2 and the error using isql will be changed to the original one.

	unixuser\@dsliaa05 # >  db2 connect to Q10F user QADMIN using QADMIN
	SQL10007N Message "-1390" could not be retrieved.  Reason code: "3".
	unixuser\@dsliaa05 # > isql -v Q10F qadmin qadmin
	[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
	[ISQL]ERROR: Could not SQLConnect

Thanks,
Chunmei Wu


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

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
_______________________________________________
unixODBC-support mailing list
unixODBC-support at mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support