Example of ODBC Settings for Microsoft SQL Server

The following example illustrates how you might edit odbc.ini to connect to a Data Source database, such as sqldata, on Microsoft SQL Server 2005 (on HP-UX), using a vendor-supplied ODBC driver. You can make a separate entry to connect to the OLAP Metadata Catalog database.

[ODBC Data Sources]
sqldata=SQL Server 2005 Source Data on HP-UX

...

[sqldata]
Driver=/EPM_ORACLE_HOME/common/ODBC/Merant/6.0/Drivers/ARsqls24.so
Description=SQL Server 2005 Driver
Database=sqldata
Address=isqa17,1433
QuotedId=No
AnsiNPW=No
[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