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
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.
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
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