Example of ODBC Settings for Oracle

The following example illustrates how you might edit odbc.ini to connect to a Data Source database, oradata, on Oracle 9i (on Solaris), using a DataDirect version 5.2 ODBC driver. You can make a separate entry to connect to the OLAP Metadata Catalog database.

[ODBC Data Sources]
oradata=Oracle9i Source Data on Solaris

...

[oradata]
Driver=/EPM_ORACLE_HOME/common/ODBC/Merant/6.0/Drivers/arora24.so
Description=my oracle source
HostName=oraclehost
SID=tbc1
PortNumber=1521
[ODBC]
IANAAppCodePage=4
InstallDir=products/common/ODBC/Merant/6.0
Trace=0
TraceDll=products/common/ODBC/Merant/6.0/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0

Tip:	Run ivtestlib to verify that the environment is set to run the correct ODBC driver file. For example, run ivtestlib and paste the path and file name that follow Driver= in the odbc.ini file that you edited.