How to connect ASP with MY SQL

[klnce]

I need some example code which connects, ASP and MY SQL. please post any kind of examples. please specify the driver also.


I want to convert http://klnce.elementfx.com to a dynamic site. plz help me.:lockd:

 

[flinx]

Can't help you, I don't know anything about ASP, but googling with 'asp mysql guide' i get lots of results.

 

[Bobswat]

I got this from an article, it's not my own work but it looks like its what you want.

Driver: MySQL ODBC Driver-MyODBC 3.51

<%
Dim sConnection, objConn , objRS

sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=Your_Mysql_DB; UID=mysql_username;PASSWORD=mysql_password; OPTION=3"

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open(sConnection)

Set objRS = objConn.Execute("SELECT FirstName, LastName FROM tblUsers")


While Not objRS.EOF
Response.Write objRS.Fields("LastName") & ", " & objRS.Fields("FirstName") & "<br>"
Response.Write & " "
objRS.MoveNext
Wend

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

again just some example code I found

website is: http://www.aspdev.org/articles/asp-mysql-connect/

 

[klnce]

is x10hosting.com is capable of running asp pages? Please reply soon.

 

[diabolo]

as of currently, x10 does NOT offer ASP. Although they do plan on adding it soon. You might want to check with them if they can put ASP on your account, since I know they have put ASP per-basis.