how to configure devart ODBC for ORACLE on Linux using indirect mode.

[abarrete]

Dear Devart and Devart user

we are testing ODBC connection in 3rd solution with devart trial version.
(reference page : https://www.devart.com/odbc/oracle/docs/index.html)

but we have some touble at indirect mode connection setting
(a direct mode connection succecssfully works)

inspite of many times trial which connect using indirect mode but we can't connect. so i make inquiries

current environment is following (all in same server)
OS : Linux 32bit (centos 6.4)
database : oracle server 11g on linux 64bit
database client : oracle server 11g on linux 32bit
ODBC : DEVART_ORACLE_x86

and next is our odbc.ini and odbcinst.ini setting


odbc.ini setting

[DEVART_ORACLE_x86]
Driver=Devart ODBC Driver for Oracle x86
Direct=False
User ID=sample
Password=sample
Host=host ip or hostname
Port=Listener Port number
Database=oracle database name


odbcinst.ini setting

[Devart ODBC Driver for Oracle x86]
Driver=/usr/local/devart/odbcoracle/lib/libdevartodbcoracle.x86.so


please let me know how to configure devart ODBC for ORACLE on Linux using indirect mode

if you have sample setting odbc.ini, odbcinst.ini that successfully works with indirect mode, please let me know


thank you for your help.

[AlexP]

Hello,

To work in the Direct mode not using the Oracle clientl library, you should just set the Direct option to True:

[DEVART_ORACLE_x86]
Driver=Devart ODBC Driver for Oracle x86
Direct=TRUE
User ID=sample
Password=sample
Host=host ip or hostname
Port=Listener Port number
Database=oracle database name