Solved

Excel Macro mySql Open Connection syntax

Posted on 2006-11-09
2
1,152 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:spoowiz
2 Comments
 

Accepted Solution

by:
jschnei555 earned 250 total points
ID: 17917155
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
 

Author Comment

by:spoowiz
ID: 17919741
Works. Thanks.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question