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)
MySQL
Moderators: chulett, rschirm, roy
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
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
Regards,
Shree
785-816-0728
Shree
785-816-0728
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...
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...