DB2 OLAP V8 Installation Problem Hi. OLAP is anyone installed at 8 before? AIX machine I 'm having some problem with the installation where until now IBM Support still not able to provide me the solution. I have installed the OLAP into my server. everything goes fine except I 'm not able to connect to my database due to the ODBC driver problem. Can anyone share with me how you configure the ODBC setting? Provide the error message & your current odbc setting first! ERROR ===== [Sat Mar 18 15:44:35 2006]Local/itis/Stmtia/olapadm/Info (1013091) Beijing Command [SQLRetrieve] from user [olapadm] [Sat Mar 18 15:44:35 2006]Local/itis/Stmtia/olapadm/Info (1021003) Connection String is generated for [192.168.3.200] [Sat Mar 18 15:44:35 2006]Local/itis/Stmtia/olapadm/Info (1021006) SELECT * FROM itpstdcurcde] is generated Statement [SELECT [Sat Mar 18 15:44:35 2006]Local/itis/Stmtia/olapadm/Info (1021013) ODBC Error : Layer [S1000] ==> [] [Sat Mar 18 15:44:35 2006]Local/itis/Stmtia/olapadm/Info (1021014) Error code : Native ODBC Layer Error [80] [Sat Mar 18 15:44:35 2006]Local/itis/Stmtia/olapadm/Error (1021001) Failed to Establish Database Connection With SQL Server. See the log file for more information [Sat Mar 18 15:44:35 2006]Local/itis/Stmtia/olapadm/Warning (1080014) Transaction [0x10002 (0x441bba63.0x66cdb)] aborted due to [1021001] status. . ODBC.INI ======= [ODBC Data Sources] REPLDB=IBM DB2 ODBC DRIVER [REPLDB] Driver=$INSTHOME/sqllib/lib/db2o.o Description=DB2 OLAP Server Source Database [ODBC] Trace=0 TraceFile=odbctrace.out InstallDir=$INSTHOME/sqllib/odbclib FYI, I 'm 64 BIT with AIX 8.2.4 using DB2 5.3 ML7. First, make sure your meet the prerequisite : http : //www-306.ibm.com/software/data/db2/db2olap/docs/v82docs/esb_install/esb_installtfrm.htm?supodbc.htm Second, analyze and modify TRACE=1 client communication between ODBC and ODBC manager. To do this you may refer to MSDN. Third, make a CLI trace if the above Extract. I 'm able to connect to my db by using unixODBC but when I trying to connect using OLAP then I hit the connection error. [ Closed window ]