View Single Post
Old 25-11-2007, 02:17 AM   #4 (permalink)
ajbrun
Senior Member
 
ajbrun's Avatar
 
Join Date: Apr 2004
Location: York, England
Posts: 4,840
Thanks: 4
Thanked 25 Times in 13 Posts
Re: Help connecting to a remote MySQL server...

It's late and I'm tired, so forgive me if I misunderstand .

Try this test your connection info and get a correct connection string at the end of it:

* Create a new file somewhere with a .udl extension, then open it.
* Select the appropriate DB connection in the providers tab.
* Enter your server information, username and password in the connection tab.
* Select the database from the list.
* Click test connection. Assuming your information is correct, it should connect fine.
* Click OK.
* Open your .udl file in wordpad/notepad/similar. This should show you your connection string.
ajbrun is offline   Reply With Quote