I'm trying to configure MySql community edition on DataStage server. I'm using this version 'mysql-connector-odbc-5.3.4-linux-el6-x86-64bit.tar.gz '.
The configuration went smooth at the production server but It's not working at Dev server. I've followed the same steps mentioned in the below URL at both servers:
http://www-01.ibm.com/support/docview.w ... wg21458603
When trying to view data from DataStage Designer, I receive this error:
Code: Select all
ODBC function "SQLConnect" reported: SQLSTATE = IM003: Native Error Code = 0; Msg = [DataDirect][ODBC lib] Specified driver could not be loaded
Code: Select all
[MySQL]
Driver=/opt/mysql/lib/libmyodbc5a.so
Description=Connector/ODBC 3.51 Driver DSN
SERVER=9.133.16.210
PORT=3306
USER=8
Password=8
Database=NEWSMS
OPTION=3
SOCKET=
DriverUnicodeType=1
Code: Select all
LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/linux-all-x86_64:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
## Netezza Home and ODBC Configuration ##
Netezza_Home=/opt/odbc64v51/lib
NZ_ODBC_INI_PATH=/opt/IBM/InformationServer/Server/DSEngine
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$Netezza_Home
export LD_LIBRARY_PATH
export NZ_ODBC_INI_PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/mysql/lib; export LD_LIBRARY_PATH
fi
Code: Select all
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = localhost
<MySQL>
DBMSTYPE = ODBC