MySQL on AIX 5.1

miamichillin99 · Post by **miamichillin99** » Mon May 16, 2005 2:03 pm

Ladies and Gentlemen,

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:

Code: Select all

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:

Code: Select all

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

Anyone that can help I would appreciate it.

ray.wurlod · Post by **ray.wurlod** » Mon May 16, 2005 6:23 pm

Use DS_CONNECT rather than CONNECT. This has authorization for the branded ODBC drivers built in.

miamichillin99 · Post by **miamichillin99** » Tue May 17, 2005 9:58 am

Ray thanks for your help. Really appreciate someone of your caliber coming to the rescue. I still got the same error:

Code: Select all

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

Anything else I can try?

miamichillin99 · Post by **miamichillin99** » Thu May 19, 2005 9:59 am

Bump!!

Anyone out there with any experience with MySQL?

marcelo_almeida · Post by **marcelo_almeida** » Fri Aug 18, 2006 11:26 am

I had a similar problem.
My .odbc.ini was configured like this:

[MySql02]
Description = MySQL ODBC 3.51 Driver DSN
Driver = /usr/lib/libmyodbc3S-3.51.12.so
Setup = /usr/lib/libodbcmyS.so
SERVER = 192.168.0.204
Database = mysql

This provoked the mistake (The connection is broken(81002)).

To solve the problem, I changed for:

[MySql03]
Description = MySQL ODBC 3.51 Driver DSN
Driver = /usr/lib/libmyodbc3-3.51.12.so
Setup = /usr/lib/libodbcmyS.so
SERVER = 192.168.0.204
Database = mysql
PTION = 3

ray.wurlod · Post by **ray.wurlod** » Fri Aug 18, 2006 10:58 pm

Welcome aboard, and thank you for posting a solution. :D

Should that last line be "PTION" or "OPTION"?
Do you know what its purpose is?

prashanto_dev · Post by **prashanto_dev** » Tue Jul 29, 2008 12:20 pm

I am also facing this issue when trying to connec to mysql.

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

Please let me how to fix this problem.

chulett · Post by **chulett** » Tue Jul 29, 2008 12:21 pm

Have you tried the solution posted above?

prashanto_dev · Post by **prashanto_dev** » Tue Jul 29, 2008 12:27 pm

yes I have tried and still getting the same problem.

[myodbc]
Driver=/usr/local/mysql/lib/libmyodbc3S-5.1.0.so
Description=MySQL ODBC 3.51 Driver DSN
SERVER=70.91.45.1
Database=edw1ops
OPTION=3

prashanto_dev · Post by **prashanto_dev** » Tue Jul 29, 2008 12:28 pm

yes I have tried and still getting the same problem.

[myodbc]
Driver=/usr/local/mysql/lib/libmyodbc3S-5.1.0.so
Description=MySQL ODBC 3.51 Driver DSN
SERVER=70.91.45.1
Database=edw1ops
OPTION=3

gup · Post by **gup** » Tue Jul 29, 2008 2:25 pm

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 ?

Matt

chulett · Post by **chulett** » Tue Jul 29, 2008 3:21 pm

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.

gup · Post by **gup** » Wed Jul 30, 2008 8:51 am

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?

Matt

gup · Post by **gup** » Wed Jul 30, 2008 8:56 am

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?

Matt

prashanto_dev · Post by **prashanto_dev** » Wed Aug 06, 2008 12:40 pm

Is anybody has answer for this problem:

I am also getting same kind of errors:

>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