动网论坛的asp 数据库连接代码

复制代码 代码如下:

<%@LANGUAGE="VBSCRIPT"%>

<%

option explicit

dim startime,endtime,conn,strCon,db

startime=timer()

Dim strSQLServerName

Dim strSQLDBUserName

Dim strSQLDBPassword

Dim strSQLDBName

'请填写数据库具体参数

'-----------------------------------------------------------------------------------------------

strSQLServerName = "127.0.0.1" '服务器名称或地址

strSQLDBUserName = "sa" '数据库帐号

strSQLDBPassword = "123" '数据库密码

strSQLDBName = "bbsbak" '数据库名称

'-----------------------------------------------------------------------------------------------

'SQL Server OLE Driver

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

strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"

conn.Open strCon

function CloseDatabase

Conn.close

Set conn = Nothing

End Function

%>