Topic
  • 1 reply
  • Latest Post - ‏2013-04-24T20:29:21Z by ThuanNg
SystemAdmin
SystemAdmin
7754 Posts

Pinned topic ODBC connector on AIX 6.1 compatible with DataStage 8.7 and MySQL Community

‏2013-03-31T14:35:54Z |
Hi,
As we all know, the ODBC driver supplied by IBM only works with MySQL Enterprise Edition. We visited the MySQL website but couldn't locate a driver for AIX.

Our server admin has procured a customized version, which when used on AIX 6.1 with DataStage 8.7 throws the following error:

DSD.BCIOpenR call to function SQLTables failed.
SQLSTATE=S1004, DBMS.CODE=0
DataStageSQL ClientAn unsupported SQL data type was encountered

Could someone help us to find the right ODBC connector for MySQL Community Edition that works on AIX and is compatible with DataStage 8.7?

If one doesn't exist, kindly provide us with a step by step guide that will help us to compile from source on AIX 6.1.
  • ThuanNg
    ThuanNg
    1 Post

    Re: ODBC connector on AIX 6.1 compatible with DataStage 8.7 and MySQL Community

    ‏2013-04-24T20:29:21Z  

    Have you had any progress on this yet?

    If not , give it a go with the attached driver.

    Have this entry in your .odbc.ini

    [ODBC Data Sources]

    DSN-name=MySQL

    ....

    [DSN-name]
    Driver=/sw/IBM/InformationServer87/Server/branded_odbc/lib/libmyodbc3-3.51.27.so
    Server=217.65.224.202
    Database=<databasename>
    Port=3306

    Attachments

    Updated on 2013-04-24T20:34:55Z at 2013-04-24T20:34:55Z by ThuanNg