Using ODBC to connect to Oracle under Linux

From: Leandro Dardini <ldardini_at_tiscali.it>
Date: Sat, 17 Sep 2005 07:22:20 +0200
Message-ID: <gKNWe.39532$TR5.36933@news.edisontel.com>

Hi,
installing the latest Oracle 10 client on Linux I install also the ODBC driver. My purpose is to use (unix)ODBC to connect to Oracle from a wide range of application running under Linux, from php to simple CLI using isql. Oracle 10 client fills my odbcinst.ini with the following data:

[Oracle]

Description             = ODBC for Oracle
Driver          = /usr1/oracle/product/10.2.0/client_1/lib/hsdb_odbc.so
Setup           =
FileUsage               = 1
CPTimeout               =
CPReuse         =

But I don't know what data to put in the odbc.ini to let my applications to connect to my database. I have a correctly filled tnsnames.ora who let me to connect to database with sqlplus.

ORCL_DBSVILUPPO =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = DBSVILUPPO)(PORT = 1521))     )
(CONNECT_DATA = (SID = ORCL)(SERVER = DEDICATED))
  )

Is there anyone who know how to fill odbc.ini and can provide me an example?

Thank you

Leandro Received on Sat Sep 17 2005 - 00:22:20 CDT