[unixODBC-support] Unable to get isql working on AIX 7.1

Sundar Mahadevan sundarmahadevan82 at gmail.com
Thu Jan 28 15:03:49 GMT 2016


Hi Kevin and Nick,
Many thanks for your help. I was able to get isql working. I needed to
unset LIBPATH on my aix machine and it started working. I am trying to test
my db2 database connection with isql and i cant get it to work. Could you
please assist? Thanks.

oracle at omsa4103:SUPCON(/home/oracle/bin/UnixOdbcDriverManager/etc)> cat
odbc.ini
[BPMSIT]
Description     = ODBC for DB2
Driver          = /u13/app/DBCLIENT/sqllib/lib64/db2_64.o
Database        = BPMDB
Instance        = psinst1
Protocol        = TCPIP
Hostname        = oms420.omers.com
ServiceName     = 50000
uid             = db2ro
pwd             = *****

oracle at omsa4103:SUPCON(/home/oracle/bin/UnixOdbcDriverManager/etc)> cat
odbcinst.ini
[BPMSIT]
Description     = IBM DB2 ODBC driver (64-bit)
Driver          = /u13/app/DBCLIENT/sqllib/lib64/db2_64.o
FileUsage       = 1
DontDLClose     = 1
Debug           = 1
CommLog         = 1

[ODBC]
Trace           = Yes
TraceFile       = /tmp/odbctrace.out

dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> \rm /tmp/odbctrace.out

dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> env | grep ODBCINI
ODBCINI=/home/oracle/bin/UnixOdbcDriverManager/etc/odbc.ini

dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> export DB2INSTANCE=psinst1
dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> isql -v BPMSIT
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV
failed
[ISQL]ERROR: Could not SQLConnect
dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> cat /tmp/odbctrace.out
.
.
.
[[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV
failed]
.
.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20160128/2bf2e52d/attachment.html>


More information about the unixODBC-support mailing list