Connection to MySQL server on remote machine via ODBC

[Luk]

Hi!
I'm trying to get table definition and data from MySQL server on remote machine.
I'm using DataStage 7.5 on Linux, unixODBC drivers and myODBC drivers. Connection to localhost works OK! Connection to remote MySQL is OK, but when I want to import MetaData I have an error:

Error calling subroutine: DSR_IMPORT (Action=3); check DataStage is set up correctly in project test
(The connection is broken (81002))

and my connection is broken definitevely.

I have noticed that, when I'm testing connection under DS shell (command CONNECT) - everything works fine until there is an incorrect SQL statment - I don't get error message but something like this:

Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program CONNECT at address ac0.
Segmentation fault

Any Ideas? Please help!
Thanks!!

[ogmios]

Error 81002 is the general "connection broken" error. I would suggest raising a ticket with Ascential. Segmentation faults are usually hard bugs in DataStage code itself.

Ogmios

[Luk]

I think that may be prodlem with shared libraries version conflict.
I found sth like that:

http://bugs.mysql.com/bug.php?id=577

If you know, write how can I configure connection to MySQL under Linux, what drivers, what libraries and connection parameters I must use!

Maybe I'm doing sth wrong!

[roy]

Hi,
Are you using the branded ODBC that comes with DS?

[Luk]

yes, but in branded_odbc there is no driver to MySQL, so I must use unixODBC and MyODBC drivers!
I removed path to branded_odbc driver - and this error is still the same.

[Luk]

Still I don't know what the problem solution is but , when I have installed and started to use iODBC manager instead of unixODBC everything works fine!!