New MySQL ODBC Connection Not Working

[kenstorm]

Hello All,

Please help. I cannot get a new MySQL database to be usable with Datastage 8.7. I have tried using the 32 bit and 64 bit odbc driver that comes with MySQL.

I can get past the first part of the import, the connection and table list get populated. The issue is when I try to import ODBC metadata from a particular table from the new MySQL database, it causes this error: Error calling subroutine: DSR_IMPORT (Action=3); check DataStage is set up correctly in project STREAM_DASHBOARD_Dev.

MySQL: Installed on a 64 bit Redhat OS. MySQL is the free version which is not supported by IBM's Wire Protocol driver.

Datastage 8.7 is installed on 64 bit Redhat.

I have edited the uvodbc.config file:
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = localhost
<MySQL_QM_Stage>
DBMSTYPE = ODBC
<MySQL_QM_DataMart>
DBMSTYPE = ODBC
<IADB>
DBMSTYPE = ODBC
<DB2_XMeta>
DBMSTYPE = ODBC


I have edited the .odbc.ini file:
[MySQL_QM_Stage]
Driver=/usr/lib64/libmyodbc5.so
#Driver=/usr/lib64/libmyodbc3_r-3.51.26.so
Description=Connector/ODBC 3.51 Driver DSN
SERVER=##.#.##.#
PORT=3306
USER=
Password=
Database=BMI_QM_STAGE
OPTION=3
SOCKET=
DriverUnicodeType=1

ERROR FROM THE METADATA IMPORT:
(The connection is broken (81002))

This error occurred on 7/13/2012 at 3:25 PM (Standard format: 2012/07/13 15:25:15)

Product Version: 8.7.0.0
Client tag: 229cd8ac-ce03-4570-8a46-ede2eaba2d56
See log: C:\IBM\InformationServer\Clients\Classic\%USERPROFILE%\ds_logs\dstage_wrapper_trace_20.log
Application: dsdesign.exe (PID 5112)
Operating System: Windows 7 6.1 Service Pack 1
Detected: WOW64 (windows running on Windows 64-bit)
.NET Framework version: 4.0.30319.269
Machine Name: WIN7-105
User Name: me...
Language: English (United States)
Time Zone: Central Daylight Time

Error message:
Error calling subroutine: DSR_IMPORT (Action=3); check DataStage is set up correctly in project STREAM_DASHBOARD_Dev

(The connection is broken (81002))

[ray.wurlod]

Is there an entry for MySQL_QM_Stage in the list of ODBC data source names at the top of .odbc.ini ?

[kenstorm]

Thanks Ray.

Yes, there is an entry in the .odbc.ini, see below.

[ODBC Data Sources]
MySQL_QM_Stage=MyODBC 3.51 Driver DSN
MySQL_QM_DataMart=MyODBC 3.51 Driver DSN

[ArndW]

What datatypes does this table contain? Can you try to import a sample tabel with just integer and varchar columns to check whether it might have something to do with datatypes. I had a similar problem this past week where the import crashed and I found that there was a column of type "pdf" hidden in there which caused my abort/crash.

[narasimha]

We have the same issue on our new 8.7 installation.
Can you please share how you resolved it (If resolved).