The following example illustrates how you might edit odbc.ini to connect to a Data Source database, such as db2data on IBM DB2 version 8.2 (on AIX), using a DataDirect Wire Protocol driver. You can make a separate entry to connect to the OLAP Metadata Catalog database.
Use the vi $ODBCINI command to edit the odbc.ini file and insert the following statements:
[ODBC Data Sources] db2data=DB2 Source Data on AIX ... [db2data] Driver=/EPM_ORACLE_HOME/common/ODBC/Merant/6.0/Drivers/ardb222.so IpAddress=isaix7 Database=tbd7a7n TcpPort=50000 Package=PACK4A Action=REPLACE QueryBlockSize=8 CharSubTypeType=SYSTEM_DEFAULT ConversationType=SINGLE_BYTE CloseConversation=DEALLOC UserBufferSize=32 MaximumClients=35 GrantExecute=1 GrantAuthid=PUBLIC OEMANSI=1 DecimalDelimiter=PERIOD DecimalPrecision=15 StringDelimiter=SINGLE_QUOTE IsolationLevel=CURSOR_STABILITY ResourceRelease=DEALLOCATION DynamicSections=32 Trace=0 WithHold=0 [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