Page 1 of 1

Error: ODBC - Specified driver could not be loaded

Posted: Tue Mar 17, 2009 8:46 am
by RaviReena
I am validating my new installation of Information Analyzer v 8.1 under Analysis Database/Validate Engine connection. it is failed and here is the output in iasHandler.log.

2009-03-17 10:38:19,620 Error [IBM-IA-HANDLER] [] AnalysisSessionImpl.java:186 Job 15: PxValidation00689903: aborted
2009-03-17 10:38:19,620 Error [IBM-IA-HANDLER] [] AnalysisSessionImpl.java:186 Job failure log
============
2009-03-17 10:38:19,621 Error [IBM-IA-HANDLER] [] AnalysisSessionImpl.java:186 Event 1: pxbridge: Error when checking operator: ?? (IIS-CONN-ODBC-000004; OD
BC function {0} reported: SQLSTATE = IM003: Native Error Code = 0: Msg = [DataDirect][ODBC lib] Specified driver could not be loaded; CC_OdbcConnection; con
nect; CC_OdbcConnection.cpp; 416)
Error when checking operator: ?? (IIS-CONN-ODBC-000004; ODBC function {0} reported: SQLSTATE = 08003: Native Error Code = 0: Msg = [DataDirect][ODBC lib] Co
nnection not open; CC_OdbcConnection; rollback; CC_OdbcConnection.cpp; 895)
Event 2: main_program: Could not check all operators because of previous error(s)
Event 3: main_program: Creation of a step finished with status = FAILED.

2009-03-17 10:38:19,650 Error [IBM-IA-HANDLER] [] AnalysisSessionImpl.java:186
Job failed:CleanupPxValidation

2009-03-17 10:38:24,058 Error [IBM-IA-HANDLER] [] Error executing DS job: Check the log file for more details about the error



Can any one please suggest what could be the problem.

Posted: Thu Mar 19, 2009 5:21 am
by sima79
Have you created a DSN for the information analyzer database (IADB)?

You can edit this information in the odbc.ini file in the DSEngine directory