Forum Moderators: mack

Message Too Old, No Replies

Having probs connecting to mysql db with asp!

         

infernofiasco

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

10+ Year Member



<%
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?

txbakers

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

WebmasterWorld Senior Member 10+ Year Member



what version mySQL?
what version myODBC?

These are important.