DSXchange

Posted: **Thu Jul 02, 2015 1:26 am**

Hi,
When trying to connect to MySQL server , I am getting error "Connections to MySQL Community Servers are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial".

This is the first time we are trying to connect to MySQL from ETL. I did search on this error message and found that , DataStage can connect to only Enterprise or Commercial server.

Do we have any workaround to connect to community server from datastage.

Thanks

Posted: **Thu Jul 02, 2015 2:24 am**

Yes, obtain a MySQL Enterprise or Commercial. Or, perhaps, use ODBC.

Posted: **Thu Jul 02, 2015 2:36 am**

ODBC stage is also giving same error..

Posted: **Thu Jul 02, 2015 6:23 am**

Then it would seem that you'll need to upgrade to a non-free / open source version of the database.

Posted: **Sat Jul 04, 2015 10:01 pm**

We use the free version to test concepts. The ODBC works fine. You either have a driver issue or a user/pwd issue.

Posted: **Sun Jul 05, 2015 6:31 am**

Interesting... back when I searched for this error message found several sites with information like this, hence my comment.

Posted: **Sun Jul 05, 2015 9:36 am**

Craig, maybe it is an older version of MySQL. I have never had a problem. We use Java as well to connect to it. He might not be starting MySQL properly as well. So the service is not running.

Posted: **Mon Jul 06, 2015 11:52 pm**

Hi Kim,
Any idea what version of ODBC driver you used to connect. Currently we are having 5.3

Posted: **Sat Jul 11, 2015 12:39 pm**

I am on 6.1 CE

Posted: **Thu Jul 30, 2015 3:48 am**

Downloaded new driver from internet and copied *.so files to /lib directory. After that I am able to connect.

DSXchange

Could not connect to MySQL

Could not connect to MySQL