Page 1 of 1
MySQL
Posted: Tue May 25, 2010 12:29 pm
by Sreedhar
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)
Posted: Tue May 25, 2010 12:46 pm
by asorrell
You need to post those details - show us the entries you put in .odbc.ini and uvodbc.config.
Posted: Tue May 25, 2010 1:38 pm
by Sreedhar
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
Posted: Tue May 25, 2010 1:45 pm
by Sreedhar
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."
Posted: Tue May 25, 2010 1:50 pm
by vinnz
Are you connecting to SQL Server or MySQL ?
Posted: Tue May 25, 2010 1:56 pm
by asorrell
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...