Windows ODBC not connecting to MySQL

Win7 pro running WAMP as server with mysql db. Desktop on same network with Win10, both 64 bit OS. Can ping systems ok. Have mysql connectors version 5.2 on each system. On WAMP system the ODBC tests successful with connecting to mysql. The desktop system comes up with the error 'can't connect...' when trying to test the connection. In doing an odbc trace, the only message that may have a bearing on the problem is 'DIAG [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)'. Not sure how to trouble shoot this. Any help greatfully appreciated
jsgouldAsked:
Who is Participating?
 
arnoldCommented:
Are you setting up a system DSNnusing MySQL odbc connection?
How are you testing! Connection string from php code?
0
 
jsgouldAuthor Commented:
Thanks again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here