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!!
Connection to MySQL server on remote machine via ODBC
Moderators: chulett, rschirm, roy
Re: Connection to MySQL server on remote machine via ODBC
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
Ogmios
In theory there's no difference between theory and practice. In practice there is.
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!
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!
Hi,
Are you using the branded ODBC that comes with DS?
Are you using the branded ODBC that comes with DS?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org