Guru Of Geeks

1.Shutdown the mysql server 2.Open the my.ini file found in the directory where you installed mysql usually “C:\ProgramFiles\MySQL\MySQL Server 5.0\my.ini” or "C:\ProgramData\MySQL\MySQL Server 5.5"

Download the open source MySQL ODBC Connector from MySQL.com. Example file name for 32-bit linux platforms: mysql-connector-odbc-5.1.6-linux-glibc2.3-x86-32bit.tar.gz Extract the file contents to a directory of your choice and make sure the directory is added to the end of the load library path environment variable in your dsenv file. Example for Linux: LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/mysql_odbc/lib/; export LD_LIBRARY_PATH After modifying the dsenv file, you must stop and restart the DataStage Engine. Add a DSN entry to your .odbc.ini file, located in $DSHOME. Note that this example contains annotations for the various properties. You must remove these annotations when updating your actual .odbc.ini file. [DataSourceName] Driver=/opt/mysql_odbc/lib/libmyodbc5.so (put your own path and driver name in here) Description=Connector/ODBC 3.51 Driver DSN SERVER=<<ServerName>> PORT=3306 USER= Password= Database=<<DatabaseName...