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

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

Postby abarrete » Fri 13 May 2016 01:41

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.
abarrete
 
Posts: 1
Joined: Fri 13 May 2016 00:52

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

Postby AlexP » Fri 13 May 2016 05:14

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
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to ODBC Drivers