Originally posted by: Balasubramanian G

Hi,

While try to connect oracle database via ODBC, getting the below error that ODBCINI variable is not set properly. I have tried to set using the command export ODBCINI='path of ODBC.ini" but still getting the same error. Do we need to update any config file for the same in ITXA environment.

[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.

SQL State: IM002
SQLConnect failed.
Database connect status: rc = -1005, count = 0.
Returned status: (-1005) Failed_to_connect_to_the_database
 

Thanks,

Bala

Originally posted by: PaulBrett

I think you may also need to add the ODBC drivers directory to the LIBPATH variable.  (DTX_HOME_DIR/odbc_drivers/lib)

Thank you.

Paul

Follow me on Twitter