Welcome to WebmasterWorld Guest from 184.72.177.182

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
posts:51
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
posts:4392
votes: 0


what version mySQL?
what version myODBC?

These are important.