單一連線檔案,透過 DataLinkType 參數切換 Access / SQL Server 連線字串,集中錯誤處理與關閉邏輯。
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim DataLinkType, conn, connStr, MyDbPath
MyDbPath = "data/Database.mdb"
DataLinkType = 0 ' 0=Access, 1=SQL Server
If DataLinkType = 0 Then
' Access
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(MyDbPath)
Else
' SQL Server (SQL Native Client)
connStr = "Provider=SQLNCLI; Server=.\SQLEXPRESS; uid=sa; pwd=windows; database=data1;"
End If
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connStr
If Err.Number <> 0 Then
Err.Clear
Set conn = Nothing
Response.Write "資料庫連線失敗,請檢查連線字串。"
Response.End
End If
' 關閉連線副程式
Sub CloseConn()
On Error Resume Next
conn.Close
Set conn = Nothing
End Sub
%>
<!--#include file="conn.asp"-->
<%
Set rs = conn.Execute("SELECT * FROM news")
' ...
Call CloseConn()
%>
web.config(ASP.NET)或註冊表/環境變數。GetRS(sql, params) 封裝參數化查詢。