asp可以跟mysql连接嘛

<%@ Language=VBScript %>
<%
Dim conn, rs
Dim connStr, sql

' 连接字符串
connStr = "Provider=MSDASQL;Driver={MySQL ODBC 8.0 Unicode Driver};Server=localhost;Database=mydatabase;Uid=myuser;Pwd=mypassword;"

' 创建连接对象
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connStr

' 执行SQL查询
sql = "SELECT * FROM mytable"
Set rs = conn.Execute(sql)

' 输出结果
Do While Not rs.EOF
    Response.Write rs("column_name") & "<br>"
    rs.MoveNext
Loop

' 关闭连接
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>

<%@ Language=VBScript %>
<%
Dim conn, rs
Dim connStr, sql

' 连接字符串
connStr = "DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=localhost;DATABASE=mydatabase;UID=myuser;PWD=mypassword;"

' 创建连接对象
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connStr

' 执行SQL查询
sql = "SELECT * FROM mytable"
Set rs = conn.Execute(sql)

' 输出结果
Do While Not rs.EOF
    Response.Write rs("column_name") & "<<br>"
    rs.MoveNext
Loop

' 关闭连接
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>