Mysql connection string in asp

by Ramya 2009-08-31 18:47:28

Mysql connection string in ASP:

To connect Mysql Database in ASP:
<%
Dim sConnection, objConn , objRS
sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=test; UID=root;PASSWORD=; OPTION=3"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(sConnection)
Set objRS = objConn.Execute("create table test(id bigint(20) PRIMARY KEY auto_increment)")
%>

Driver : MYSQL Database Driver
Server : Your web server
Database : Database name
UID : database username
Password : database Password

Tagged in:

1243
like
0
dislike
0
mail
flag

You must LOGIN to add comments