MySql Connection Issue In Datastage 11.5
Moderators: chulett, rschirm, roy
You had an extra character in there (the Control-V, perhaps from an arrow key). The "traceroute" command is a Standard UNIX/AIX command and is most certainly present on your Server.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Here is the result :
admin@p2lp18:/home/admin>traceroute 13.250.184.188
trying to get source for 13.250.184.188
source should be 10.47.0.93
traceroute to 13.250.184.188 (13.250.184.188) from 10.47.0.93 (10.47.0.93), 30 h ops max
outgoing MTU = 32768
1 * * *
2 * * *
3 * * *
4 * * *
5 * * *
6 * * *
7 * * *
8 * * *
9 * * *
10 * * *
11 * * *
12 * * *
13 * * *
14 * * *
15 * * *
16 * * *
17 * * *
18 * * *
19 * * *
20 * * *
21 * * *
22 * * *
23 * * *
24 * * *
25 * * *
26 * * *
27 * * *
28 * * *
29 * * *
30 * * *
admin@p2lp18:/home/admin>traceroute 13.250.184.188
trying to get source for 13.250.184.188
source should be 10.47.0.93
traceroute to 13.250.184.188 (13.250.184.188) from 10.47.0.93 (10.47.0.93), 30 h ops max
outgoing MTU = 32768
1 * * *
2 * * *
3 * * *
4 * * *
5 * * *
6 * * *
7 * * *
8 * * *
9 * * *
10 * * *
11 * * *
12 * * *
13 * * *
14 * * *
15 * * *
16 * * *
17 * * *
18 * * *
19 * * *
20 * * *
21 * * *
22 * * *
23 * * *
24 * * *
25 * * *
26 * * *
27 * * *
28 * * *
29 * * *
30 * * *
Isn't that a different product entirely?
https://downloads.mariadb.org/mariadb/5.5.56/
While the pages I looked at seem to indicate that MariaDB is a 1:1 drop-in replacement for MYSQL, it would seem that this does not apply to the DataDirect ODBC Driver.
https://downloads.mariadb.org/mariadb/5.5.56/
While the pages I looked at seem to indicate that MariaDB is a 1:1 drop-in replacement for MYSQL, it would seem that this does not apply to the DataDirect ODBC Driver.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
A quick quote from https://blog.panoply.io/a-comparative-vmariadb-vs-mysql :
MariaDB is a fork of MySQL (and yes, it is designed to be a drop-in replacement)
...
- data and table definition files are compatible
- client protocols, structures, and APIs are identical
- MySQL connectors will work with MariaDB without modification
Regarding the new error, it looks like, as the error indicates, that the bundled Progress DataDirect mysql driver does not support connecting to the free community edition:
This quote is from https://knowledgebase.progress.com/arti ... ticle/5155 :
If the resulting string value mentions that this is a MySQL Commercial or MySQL Enterprise server, then the DataDirect Connect for ODBC MySQL drivers will connect. If the string mentions that this is a MySQL Community server, the DataDirect Connect for ODBC drivers will not connect.
MariaDB is a fork of MySQL (and yes, it is designed to be a drop-in replacement)
...
- data and table definition files are compatible
- client protocols, structures, and APIs are identical
- MySQL connectors will work with MariaDB without modification
Regarding the new error, it looks like, as the error indicates, that the bundled Progress DataDirect mysql driver does not support connecting to the free community edition:
This quote is from https://knowledgebase.progress.com/arti ... ticle/5155 :
If the resulting string value mentions that this is a MySQL Commercial or MySQL Enterprise server, then the DataDirect Connect for ODBC MySQL drivers will connect. If the string mentions that this is a MySQL Community server, the DataDirect Connect for ODBC drivers will not connect.
Choose a job you love, and you will never have to work a day in your life. - Confucius
To Craig's point, we are not the official support provider, so it's too early to conclude that there is no way to connect. Contact support to confirm. I hope there is a way or there will be a way soon. If you do contact support, please let us know what you find out.
There is also this IBM technote where they have documented a way, but also clearly state they do not support it, so you would be on your own if you run into issues...
http://www-01.ibm.com/support/docview.w ... wg21458603
There is also this IBM technote where they have documented a way, but also clearly state they do not support it, so you would be on your own if you run into issues...
http://www-01.ibm.com/support/docview.w ... wg21458603
Choose a job you love, and you will never have to work a day in your life. - Confucius