Thread: ASP and MYSQL
View Single Post
  #3 (permalink)  
Old Aug 16th, 2006, 16:56
Paula Paula is offline
Junior Member
Join Date: Aug 2006
Location: UK
Age: 23
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Re: ASP and MYSQL

Umm this is how I connect to the MySQL database with ASP, I think this is what you're asking?

<%
set objConn=server.CreateObject("ADODB.Connection")

strConn="Driver={MySQL ODBC 3.51 Driver}; Server=localhost; database=databasename; uid=userid; pwd=password; port=3307; option=1;"

objConn.Open strConn%>

Replace databasename, userid, password and I don't know about port. Depends on the port the database is running from...or something.
Reply With Quote