ASP links Mysql and reads data
<%
'ASP link mysql program
'Need to load mySQLODBC driver download address
Http://www.mysql.com/downloads/api-myodbc-2.50.html
'E-mail: kaxue@hotmail.com QQ: 484110 HomePage:
www.flyday.net
'Sash Time: Thursday, May 23, 2002 5:54 PM Win2000 Server IIS5 test
StrConnection = "DSN = USER"
'strconnection = "defaultdir =; driver = {myodbc driver}; Database = BBS"
Set adodataconn = server.createObject ("adodb.connection")
Adodataconn.open strandnection
Strquery = "SELECT * from user where username =" kaxi ""
SET RS = Server.createObject ("AdoDb.Recordset")
Rs.Open Strquery, StrConnection, 2, 1
Response.Write Rs.Recordcount
IF not ly r
%>