Problem connecting to Oracle on AIX via ODBC

mj10044 has asked for the wisdom of the Perl Monks concerning the following question:

Testing ODBC connectivity to Oracle on AIX 5.3 using Oracle ODBC driver. Checked $ORACLE_HOME variable, made sure LIBPATH and LD_LIBRARY_PATH is set correctly, added DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/dvlp/oracle/product/10.2.0/db_1} Error message below: DBI connect('grizzly','system',...) failed: unixODBC Driver ManagerDriver's SQLAllocHandle on SQL_HANDLE_HENV failed (SQL.pl line 5 unixODBC Driver ManagerDriver's SQLAllocHandle on SQL_HANDLE_HENV failed (SQL-IM004) Any suggestions graciously accepted. Thanks

Comment on Problem connecting to Oracle on AIX via ODBC

Replies are listed 'Best First'.
Re: Problem connecting to Oracle on AIX via ODBC by mje (Curate) on Jul 19, 2010 at 15:44 UTC
99.99% of the time the error you are getting means ORACLE_HOME is not set. I see you've attempted to set it in unixODBC but I'd suggest you set it in your shell and export it and retry as the unixODBC syntax ini file syntax is relatively recent.	[reply]