Excel Macro mySql Open Connection syntax

I currently use:
   cnn.Open "DSN=myodbc3-test"
which works well until some other program modifies the default content of the DSN.

I want to specify the domain, db, user, pswd. Please help me with syntax. Thanks.

I got this syntax, but how do I specify the domain/IP?
cnn.Open "Provider=myodbc3-test;Data Source=v2_db;User Id=v2_user;Password=mypswd;"

thanks
spoowizAsked:
Who is Participating?
 
jschnei555Connect With a Mentor Commented:
Can you just use someting like this instead?  

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"
0
 
spoowizAuthor Commented:
Works. Thanks.
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.