I've been trying to get this set up and it's impossible. I have DS 7x running on AIX 5.1. I wan't to connect to a remote machine running Linux and MySQL. I set up the uvodbc.config and .odbc.ini files correctly. When I try to import metadata in DS Designer is errors out like below:
Error calling subroutine: DSR_IMPORT (Action=2); check DataStage is set up correctly in project LMS
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_SELECT (Action=4); check DataStage is set up correctly in project LMS
(The connection is broken (81002))
Then when I try to connect using dssh on the AIX box I get this error:
>CONNECT MySQL_TESTING
Enter username for connecting to 'MySQL_TESTING' DBMS [dsadm]: root
Enter password for root:
Abnormal termination of DataStage.
Fault type is 4. Layer type is BASIC run machine.
Fault occurred in BASIC program CONNECT at address ab8.
Illegal instruction(coredump)
>DS_CONNECT MySQL_TESTING
Enter username for connecting to 'MySQL_TESTING' DBMS [dsadm]: root
Enter password for root:
Abnormal termination of DataStage.
Fault type is 4. Layer type is BASIC run machine.
Fault occurred in BASIC program DS_CONNECT at address ab8.
Illegal instruction(coredump)
I am having issues on Linux - except that I have "mysql-3.23.58-16.RHEL3.1" installed - but I do not have an ODBC driver associated with this client installation.
hmmm- so I may remove this RPM and re-install the newest client - but am running Linux 3 R4 on this box, so not sure if I want to do that.
Is there a preferred way to install MySQL so that I can get the proper driver and entry into .odbc.ini ?
Installing a database, MySQL or otherwise, does nothing to DataStage or its ODBC config files. The installation of the "branded ODBC" components all happens when you install the DataStage server.
-craig
"You can never have too many knives" -- Logan Nine Fingers
I have Linux 3 Release 4 - and it currently has "mysql-3.23.58-16.RHEL3.1" installed - but I cannot find any ODBC ( SO library files) to use with Datastage ?
Can I download these files so I can configure a connection somewhere?
I have Linux 3 Release 4 - and it currently has "mysql-3.23.58-16.RHEL3.1" installed - but I cannot find any ODBC ( SO library files) to use with Datastage ?
Can I download these files so I can configure a connection somewhere?
>CONNECT myodbc3
Enter username for connecting to 'myodbc3' DBMS [dsadm]: edw01
Enter password for edw01:
Abnormal termination of DataStage.
Fault type is 4. Layer type is BASIC run machine.
Fault occurred in BASIC program CONNECT at address ac0.
Illegal instruction