MQSeries.net :: View topic - Specified driver could not be loaded

rmbowma

I am using Broker 6.1.0.3 on WinXP+SP2.

My Broker runtime uses the default configuration, that is, Derby is used for the Broker database.

I have installed DB2 ESE V9.1 for application databases.

Everything seemed to be fine: Broker's running OK. I created a new DB2 database and table for my appl data. I can create my Data Design Project using the Wizard for my appl table. I created an ODBC System DSN successfully for my appl table and can connect to it via Window's ODBC 'Test connection' button.

In my msg flow, I have a DataInsert Node and have specified my DSN on the Basic tab. When my Node executes, control goes out the Failure terminal and in my Trace Node ExceptionList output I see 'Specified driver could not be loaded due to system error 127 (IBM DB2 ODBC DRIVER - DB2COPY1).'

This is all the error info I get. I even turned ODBC trace on but get no output in the trace file.

I am not a database person. Anybody have any idea what my problem could be? My only guess is having Derby and DB2 on my PC might somehow be causing me problems.