让ASP也可以连接MYSQL

本文前提是下载MYSQLX 地址为http://www.amedea.cz/mysqlx/DownloadFiles/MySQLX.zip
这个工具其实是MYSQL的组件对象模块.同样它也支持Delphi, Visual Basic, Visual C++, C++ Builder等工具的调用.以下是在ASP里的调用方法.
正确安装MYSQLX之后.ASP即可用一下方法访问MYSQL

1@ language="JavaScript"

...

1   
2con = Server.CreateObject("MySQL.Connection");   
3con.Connect("localhost", "root", "", "MyDatabase", 3306, 0);   
4sql = "select FirstName, LastName from Customers";   
5if (!con.Query(sql))   
6Response.Write("ERROR: ".concat(con.ErrMsg()));   
7else   
8{

1<table>
2<tr>
3<td class="header">   
4First name   
5</td>
6<td class="header">   
7Last name   
8</td>
9</tr>

rs = Server.Create("MySQL.RecordSet");
rs.Connection = con;
while (rs.Next())
{

1<tr>
2<td class="row">

= rs["FirstName"]

1</td>
2<td class="row">

= rs["LastName"]

1</td>
2</tr>

};

1</table>

1   
2};

...