Welcome to WebmasterWorld Guest from

Forum Moderators: brotherhood of lan & mack

Message Too Old, No Replies

Having probs connecting to mysql db with asp!

9:12 am on Apr 20, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:July 15, 2003
votes: 0

myDSN = "Driver={MySQL};DATABASE=logfile;SERVER=localhost;PORT=3306;UID=fish;PWD=;"
Set DBConnection = Server.CreateObject("ADODB.Connection")
DBConnection.Open myDSN

Iam currently tryin to use this connection type to connect to my my sql db. I ve installed mysql odbc on the server and the pc that i do the designing on.

Where am i going wrong?

11:50 am on Apr 20, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
votes: 0

what version mySQL?
what version myODBC?

These are important.