MySQL

Sreedhar · Post by **Sreedhar** » Tue May 25, 2010 12:29 pm

Hi All,

I am trying to establish connection between my Data Stage and MySQL.

I am getting the following error. I did enter the details of this under .odbc

[DataDirect][ODBC lib] Data source name not found and no default driver specified)

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue May 25, 2010 12:46 pm

You need to post those details - show us the entries you put in .odbc.ini and uvodbc.config.

Sreedhar · Post by **Sreedhar** » Tue May 25, 2010 1:38 pm

odbc.ini

walldb=DataDirect SQL Server Wire Protocol driver

[walldb]
Driver=/opt/IBM/InformationServer/v81/Server/branded_odbc/lib/VMmsss23.so
Description=DataDirect SQL Server Wire Protocol driver
Database=walldb
LogonID=User
Password=Passwd
Address=192.100.0.0,3306
QuotedId=No
AnsiNPW=Yes

UVcongif

<walldb>
DBMSTYPE = ODBC

Sreedhar · Post by **Sreedhar** » Tue May 25, 2010 1:45 pm

This is the error message I am getting

"Resource bundle corresponding to message key return code {0} from SQLConnect(handle, {1}, ****, {2}) with message {3} not found! Check that DSHOME or APT_RESPATH is set."

vinnz · Post by **vinnz** » Tue May 25, 2010 1:50 pm

Are you connecting to SQL Server or MySQL ?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue May 25, 2010 1:56 pm

Vinnz beat me to it - but that is the issue from what I can see. It looks like you are trying to connect to the Open Source "MySQL" database using the IBM bundled drivers for "Microsoft SQL Server" - two entirely different databases.

IBM doesn't bundle drivers for MySQL... You'd have to find and install drivers and then try to configure them correctly in .odbc.ini - something that may or may not work...