让ASP也可以连接MYSQL-ASP教程,ASP应用

这个工具其实是mysql的组件对象模块.同样它也支持delphi, visual basic, visual c++, c++ builder等工具的调用.以下是在asp里的调用方法.

正确安装mysqlx之后.asp即可用一下方法访问mysql

<%@ language="java script" %>

…

<%

con = server.createobject("mysql.connection");

con.connect("localhost", "root", "", "mydatabase", 3306, 0);

sql = "select firstname, lastname from customers";

if (!con.query(sql))

response.write("error: ".concat(con.errmsg()));

else

{

%>

<table>

<tr>

<td class="header">

first name

</td>

<td class="header">

last name

</td>

</tr>

<%

rs = server.create("mysql.recordset");

rs.connection = con;

while (rs.next())

{

%>

<tr>

<td class="row">

<%= rs["firstname"] %>

</td>

<td class="row">

<%= rs["lastname"] %>

</td>

</tr>

<%

};

%>

</table>

<%

};

%>

…