| Author |
Message
|
| kavitam |
 Posted: Thu Jul 29, 2010 1:44 am Post subject: Connection from Message broker to MYSQL |
 |
|
Novice
Joined: 07 May 2008
Posts: 24
|
Hi All,
I am currently trying to connect to MYSQL using MB esql.
I am able to connect to MYSQL using ODBC drivers on Window machine. However now when I am trying to execute the same on AIX box, this is not working.
The change is we are trying to connect remote MYSQL server. We are using the id which has access to remote server.
Please find below error I am getting.
DatabaseException BIP2322E: Database error: SQL State ''IM003''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] Specified driver could not be loaded''. The error has the following diagnostic information: SQL State ''IM003'' SQL Native Error Code '0' SQL Error Text ''[DataDirect][ODBC lib] Specified driver could not be loaded''
Please suggest how to resolve. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Jul 29, 2010 1:59 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20698
Location: LI,NY
|
| kavitam wrote: |
| [DataDirect][ODBC lib] Specified driver could not be loaded |
So what did you do to make the driver available to the broker? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jul 29, 2010 2:27 am Post subject: Re: Connection from Message broker to MYSQL |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| kavitam wrote: |
| I am currently trying to connect to MYSQL using MB esql. |
MySQL is not a supported database. The only supported ODBC drivers are the DataDirect drivers that ship with Broker.
Also, Mods please split this to it's own new thread as it appears to have nothing to do with the rest of the thread.  |
|
| Back to top |
|
|
| kavitam |
| Posted: Thu Aug 05, 2010 3:14 am Post subject: |
|
|
Novice
Joined: 07 May 2008
Posts: 24
|
Hi ,
I am able to connect to MYSQL server on AIX box using :isql" command.
But when I am trying to connect using Message flow code, am getting following error.
DatabaseException BIP2322E: Database error: SQL State ''IM003''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] Specified driver could not be loaded''. The error has the following diagnostic information: SQL State ''IM003'' SQL Native Error Code '0' SQL Error Text ''[DataDirect][ODBC lib] Specified driver could not be loaded''
Please note that I need to run below export command to run the "isql" command.
export LIBPATH=/usr/local/libexec:/usr/local/samba/lib:/clocal/udb/srvr1387/sqllib/lib64
But this is not working for message flow esql code.
Please provide your views.
I know that MYSQL is not officially supported by IBM, but if we are able to connect through "isql" command on AIX , then I believe we can do through code as well. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 05, 2010 3:30 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Go to v7.0.0.1 and use the Database Extender that will allow you to use ODBC drivers that are not from DataDirect. But review all of the documentation on that to ensure you know the right kinds of drivers required and that there is a version of an ODBC driver for mySQL that works.
Accept otherwise that you probably can't make this work and it will be unsupported even if you do!
Or use JDBC. |
|
| Back to top |
|
|
|
|
