Connection to MySQL server on remote machine via ODBC

[etistudent]

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!!

 

[BocaBurger]

Contact Ascential Support, if you get a segmentation fault, engineerinmg needs to get involved.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[etistudent]

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!!