Configuring Data Sources on UNIX

  To configure data sources on UNIX:

  1. Open the $ARBORPATH/bin/.odbc.ini file and add a data source description.

  2. If you add data sources or change driver products or data sources, you may need to edit the .odbc.ini file to update ODBC connection and configuration information, such as data source name and driver product name. Update instructions and requirements vary by platform.

Example: Updating .odbc.ini for DB2

Assuming this scenario:

To edit the .odbc.ini file, use the vi command and insert these example statements:

[ODBC Data Sources]
db2data=DB2 Source Data on isaix7
...
[db2data]
Driver=/vol1/Oracle/Middleware/EPMSystem11R1/common/ODBC/Merant/6.1/lib/ARdb225.so
Database=tbc_data
IpAddress=isaix7
TcpPort=50000

Note:

For detailed, driver-specific information on each DataDirect driver, see the DataDirect Connect for ODBC Reference. The location of this reference (typically within the /EPM_ORACLE_HOME/common/ ... /books/odbc/odbcref/ directory), varies depending upon the platform.