Error: ODBC - Specified driver could not be loaded

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
RaviReena
Premium Member
Premium Member
Posts: 68
Joined: Tue Jul 29, 2008 10:01 am

Error: ODBC - Specified driver could not be loaded

Post 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.
Rao V
sima79
Premium Member
Premium Member
Posts: 38
Joined: Mon Jul 16, 2007 8:12 am
Location: Melbourne, Australia

Post 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
Post Reply