MySQL dsn less connection in Dreamweaver MX04

I have only used SQL Server and Access with Dream Weaver MX but have you tried wrapping that in quotes?

 

Hi,

I've also posted this in the Dreamweaver forum, but not getting much joy. Hopefully someone in here can help me out!


I'm having trouble setting up a dsn less connection in Dreamweaver. This SHOULD work as a custom string (I think).....

DRIVER={MySQL};SERVER=mysql01.discountasp.net;DATABASE=MYSQLDB_*****;USER=****;PASSWORD=****;

But all I get is "Unidentified error ocurred". Any advice gratefully accepted.

Cheers

 

Hi wisemx,


Sorry, should've put that in the post, but tried that without success.

 

k, I did a little Googl'ing for ya and found this page:
http://www.tom-muck.com/dwteam/articles/ado/index.asp

Notice the conn string for MySQL DNS'less differs from yours so take a stab at it.




MySQL DSNless connection
driver={mysql}; database=yourdatabase;server=yourserver;uid=username;pwd=password;option=16386;

 

Thanks mate, I'll give it a go.

 

Still no luck, I've tried everything Google has to offer.


All I'm getting is unidentified error occurred.


PLEASE!! Any and all suggestions gratefully accepted! Really need to get this running!

 

what is your error message? can you post a link to a url experiencing the problem?


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET