conn.asp

来自「完美政府版,正版网站解决方案」· ASP 代码 · 共 31 行

<%
starttime=timer()

'DbType = "MSSQL" '链接MSSQL数据库
'DbType = "MYSQL" '链接MYSQL数据库
DbType = "ACCESS" '链接ACCESS数据库

if DbType="ACCESS" then
	DB = "DataBase/#####WmGOV.cn#####.asp"
	ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
end if

if DbType="MSSQL" then
	ConnStr = "driver={SQL Server};server=127.0.0.1;uid=feitium;pwd=12345678;database=FeiTium"
end if

if DbType="MYSQL" then
	ConnStr = "driver=MySQL;server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME"
end if

On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr

If Err Then
	err.Clear
	Set Conn = Nothing
	Response.Write "数据库连接出错[代码：01]，请检查数据库链接文件中的连接字串。"
	Response.End
End If
%>