<%
Const DataBaseType = 1 ' 0=Access, 1=SQL Server
If DataBaseType = 0 Then
DBPath = "/db/mydb.mdb"
SqlNowString = "Now()"
ystr = True
nstr = False
suiji = "Rnd(ID)"
Else
' === SQL Server 連線參數 ===
DataServer = "192.168.1.100" ' 資料庫伺服器 IP
DataUser = "web_user" ' 登入帳號
DataBaseName = "MyDatabase" ' 資料庫名稱
DataBasePsw = "StrongPassword123" ' 密碼
SqlNowString = "GETDATE()"
ystr = 1
nstr = 0
suiji = "NEWID()"
End If
On Error Resume Next
If DataBaseType = 1 Then
' OLE DB Provider for SQL Server (SQLOLEDB)
ConnStr = "Provider=SQLOLEDB;Data Source=" & DataServer & _
";Initial Catalog=" & DataBaseName & _
";User ID=" & DataUser & _
";Password=" & DataBasePsw
Else
' Access Jet OLEDB
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBPath)
End If
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
%>
| 參數 | 說明 | 範例 |
|---|---|---|
| Provider | OLE DB 提供者 | SQLOLEDB (SQL Server)、Microsoft.Jet.OLEDB.4.0 (Access) |
| Data Source / Server | 伺服器位址 | IP、主機名、IP,Port、Host\Instance |
| Initial Catalog / Database | 預設資料庫 | MyDatabase |
| User ID / UID | 登入帳號 | web_user |
| Password / PWD | 密碼 | ****** |
| Integrated Security | Windows 整合驗證 | SSPI (啟用時忽略 UID/PWD) |
| Application Name | 應用程式名稱 (方便追蹤) | MyWebApp |
| Connection Timeout | 連線逾時秒數 | 15 |
| Encrypt | 強制加密 (SQL 2017+) | Yes/No |
Provider=MSDASQL,或直接用 ADO.NET (ASP.NET Core)Classic ASP 已停止主流支援。新專案建議採用:
ASP 連接 SQL Server 核心在於**正確的 OLE DB 連線字串**與**錯誤處理**。現代開發請轉向支援中的技術棧,獲得更好效能、安全性與開發體驗。