Could not connect to MySQL

vinothkumar · Post by **vinothkumar** » 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

ray.wurlod · Post by **ray.wurlod** » Thu Jul 02, 2015 2:24 am

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

vinothkumar · Post by **vinothkumar** » Thu Jul 02, 2015 2:36 am

ODBC stage is also giving same error..

chulett · Post by **chulett** » 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.

kduke · Post by **kduke** » 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.

chulett · Post by **chulett** » 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.

kduke · Post by **kduke** » 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.

vinothkumar · Post by **vinothkumar** » 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

kduke · Post by **kduke** » Sat Jul 11, 2015 12:39 pm

I am on 6.1 CE

vinothkumar · Post by **vinothkumar** » 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.