MySql Connection Issue In Datastage 11.5
Moderators: chulett, rschirm, roy
MySql Connection Issue In Datastage 11.5
I have configured the odbc.ini to connect to mysql database, but when trying testing it I received a Connection Failed error
Error Message:
ODBC function "SQLConnect" reported: SQLSTATE = HY000: Native
Error Code = 2,0003: Msg = [IBM(DataDirect OEM)[ODBC MySQL Wire Protocol driver]
Can't connect to MySQL server on '13.250.184.188'
odbc.ini
[MYSQLPROD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmysql00.so
Description=DataDirect 7.0 MySQL Wire Protocol
HostName=13.250.184.188
PortNumber=3306
Database=sodv3
LogonID=
Password=
OPTION=3
SOCKET=
uvodbc.config
<SKYRPD>
MYSQLPROD = ODBC
Error Message:
ODBC function "SQLConnect" reported: SQLSTATE = HY000: Native
Error Code = 2,0003: Msg = [IBM(DataDirect OEM)[ODBC MySQL Wire Protocol driver]
Can't connect to MySQL server on '13.250.184.188'
odbc.ini
[MYSQLPROD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmysql00.so
Description=DataDirect 7.0 MySQL Wire Protocol
HostName=13.250.184.188
PortNumber=3306
Database=sodv3
LogonID=
Password=
OPTION=3
SOCKET=
uvodbc.config
<SKYRPD>
MYSQLPROD = ODBC
Using your DataStage user, can you Login to the command line on your DataStage Server and do a "ping 13.250.184.188"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
That means that your Problem doesn't lie with datastage, but that the MySQL machine at address 13.250.184.188 cannot be reached from your UNIX DataStage Server.
You should contact your machine Administrator to get access opened between the two Servers.
You should contact your machine Administrator to get access opened between the two Servers.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Is the machine "p2lp18" your DataStage engine Tier?
To which working database did you try to "ping"? Can you ping your Workstation from the Server? (If not, then the admins might have blocked ping)
To which working database did you try to "ping"? Can you ping your Workstation from the Server? (If not, then the admins might have blocked ping)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Is the machine "p2lp18" your DataStage engine Tier?
- Yes
To which working database did you try to "ping"?
- Yes. I ping'ed the MySQL connection in our engine tier which is p2lp18 and I got a one liner result. I also tried it in our database that we already using in DataStage but I got the same result.
BTW, we are using AIX.
- Yes
To which working database did you try to "ping"?
- Yes. I ping'ed the MySQL connection in our engine tier which is p2lp18 and I got a one liner result. I also tried it in our database that we already using in DataStage but I got the same result.
BTW, we are using AIX.
Can you ping your Workstation from the AIX Server?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Doing a ping is a reasonable, general test but not quite the same as making a database connection. Just because ping succeeds or fails does not mean that you will be able to connect to the database.
It is better to do a ' telnet target_db_server db_port ' command from your AIX Information Server.
If the telnet command connects OK, then double check how you defined the database connection, because if it is defined correctly then it should work.
If the telnet command times out or fails to connect, then you probably have a firewall blocking the traffic and need to get your network/firewall people to open it up.
A few other ideas:
- check your file name (the default .odbc.ini file name begins with a dot)
- list the data source name in the [ODBC Data Sources] header section of the .odbc.ini file, such as db_name=DataDirect 7.0 MySQL Wire Protocol
It is better to do a ' telnet target_db_server db_port ' command from your AIX Information Server.
If the telnet command connects OK, then double check how you defined the database connection, because if it is defined correctly then it should work.
If the telnet command times out or fails to connect, then you probably have a firewall blocking the traffic and need to get your network/firewall people to open it up.
A few other ideas:
- check your file name (the default .odbc.ini file name begins with a dot)
- list the data source name in the [ODBC Data Sources] header section of the .odbc.ini file, such as db_name=DataDirect 7.0 MySQL Wire Protocol
Last edited by qt_ky on Wed Mar 14, 2018 7:21 am, edited 1 time in total.
Choose a job you love, and you will never have to work a day in your life. - Confucius
To add to the previous post, use "Telnet 13.250.184.188 3306" to attempt to connect to the IP address and to the appropriate port as you specified in your odbc.ini
Usually "ping" is sufficient, but only at sites with no restrictions imposed by System Administration,.
Usually "ping" is sufficient, but only at sites with no restrictions imposed by System Administration,.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I tried using telnet but I got this result
admin@p2lp18:/home/dsadm>telnet 13.250.184.188 3306
Trying...
admin@p2lp18:/home/dsadm>
This is my odbc config (.odbc.ini)
[SKYRPD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmysql00.so
Description=DataDirect 7.0 MySQL Wire Protocol
HostName=13.250.184.188
PortNumber=3306
Database=sodv3
LogonID=
Password=
OPTION=3
SOCKET=
EncryptionMethod=0
ValidateServerCertificate=0
DriverUnicodeType=1
This is my uvodbc config (uvodbc.config)
<SKYRPD>
DBMSTYPE = ODBC
admin@p2lp18:/home/dsadm>telnet 13.250.184.188 3306
Trying...
admin@p2lp18:/home/dsadm>
This is my odbc config (.odbc.ini)
[SKYRPD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmysql00.so
Description=DataDirect 7.0 MySQL Wire Protocol
HostName=13.250.184.188
PortNumber=3306
Database=sodv3
LogonID=
Password=
OPTION=3
SOCKET=
EncryptionMethod=0
ValidateServerCertificate=0
DriverUnicodeType=1
This is my uvodbc config (uvodbc.config)
<SKYRPD>
DBMSTYPE = ODBC
Before going further into the Problem, can you talk to one of your AIX Administrators and explain the connectivity issues - perhaps something else is blocking connectivity.
One more thing, could you post the Output of the command "traceroute 13.250.184.188"
One more thing, could you post the Output of the command "traceroute 13.250.184.188"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>