ASP连接MySQL数据库源码如下：
'需要引用MySQL Connector/ODBC的驱动'Set up connection string for MySQL databaseDim strConnSet strConn = Server.CreateObject("ADODB.Connection")strConn.ConnectionString = "DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=mydb;UID=myuser;PWD=mypassword;"'Open the connectionstrConn.Open'Create a SQL statement to select data from a tableDim strSQLstrSQL = "SELECT * FROM mytable;"'Execute the SQL statement and return a Recordset objectDim rsSet rs = Server.CreateObject("ADODB.Recordset")rs.Open strSQL, strConn'Loop through the Recordset and display each recordDo Until rs.EOFResponse.Write rs("field1") & " | " & rs("field2") & " | " & rs("field3")rs.MoveNextLoop'Close the Recordset and Connection objectsrs.CloseSet rs = NothingstrConn.CloseSet strConn = Nothing
代码详解：
首先，我们需要引用MySQL Connector/ODBC的驱动。然后，创建一个Connection对象来存储连接字符串，并打开连接。接着，创建一个SQL语句来选择一个表中的数据，然后使用Recordset对象来执行这个语句并返回结果。最后，通过循环Recordset对象并输出每个记录来显示结果。
最后不要忘记关闭Recordset和Connection对象以及释放掉它们。
