plesk mysql nav连接_连接 MySQL 数据库使用文件 DSN 和 ASP/ADO

本示例介绍如何使用文件 DSN 和 ASP/ADO 连接 MySQL 数据库。

将 db_ 字段为您的数据库在主机控制面板中的信息。有关详细信息，请参阅了解详细信息的找到您的连接字符串。

Dim oConn, oRs

Dim qry, connectstr, sDSNDir

Dim db_name, db_username, db_userpassword

Dim db_server, dsn_name

dsn_name = "your_dsn_name"

fieldname = "your_fieldname"

tablename = "your_tablename"

sDSNDir = Server.MapPath("_dsn")

connectstr = "filedsn=" & sDSNDir & "\" & dsn_name

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.Open connectstr

qry = "SELECT * FROM " & tablename

Set oRS = oConn.Execute(qry)

if not oRS.EOF then

while not oRS.EOF

response.write ucase(fieldname) & ": " & oRs.Fields(fieldname) & "

"

oRS.movenext

wend

oRS.close

end if

Set oRs = nothing

Set oConn = nothing

%>