<%
Dim conn, connStr
' MySQL ODBC 8.0 Driver (需對應安裝 32/64-bit 版本)
connStr = "Driver={MySQL ODBC 8.0 Driver};" & _
"Server=localhost;" & _
"Database=your_database;" & _
"UID=your_username;" & _
"PWD=your_password;" & _
"Option=16386;" ' 常用選項組合
' Option 參數說明見下表
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connStr
%>
| 位元值 | 十進位 | 功能 |
|---|---|---|
| 1 | 1 | FOUND_ROWS (回傳影響行數而非匹配行數) |
| 2 | 2 | FLAG_FIELD_LENGTH (包含欄位長度資訊) |
| 4 | 4 | FLAG_TRANSACTIONS (啟用交易支援) |
| 8 | 8 | FLAG_NO_PROMPT (不提示對話框) |
| 16 | 16 | FLAG_BIG_PACKETS (大封包支援) |
| 32 | 32 | FLAG_COMPRESS (壓縮協定) |
| 64 | 64 | FLAG_SSL (SSL 加密連線) |
| 128 | 128 | FLAG_SECURE_AUTH (安全認證) |
| ... 等 | 其他進階選項 |
常用 Option=3 (1+2) 或 Option=16386 (2+16384 等組合),視驅動版本而定。
<%
Dim conn, rs, sql
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connStr
sql = "SELECT id, title, created_at FROM articles WHERE status = 1 ORDER BY created_at DESC LIMIT 10"
Set rs = conn.Execute(sql)
If Not rs.EOF Then
Response.Write ""
Do While Not rs.EOF
Response.Write "- " & rs("title") & " (" & rs("created_at") & ")
"
rs.MoveNext
Loop
Response.Write "
"
End If
rs.Close : Set rs = Nothing
conn.Close : Set conn = Nothing
%>
utf8mb4 (支援 Emoji)Charset=utf8mb4; (部分驅動支援)conn.Execute "SET NAMES utf8mb4"<%@ CODEPAGE="65001" %> + Response.Charset = "UTF-8"' 系統 DSN: my_mysql_dsn
connStr = "DSN=my_mysql_dsn;UID=username;PWD=password;"
SELECT *掌握標準 ODBC 連接字串與編碼設定,即可在 ASP 中穩定高效操作 MySQL 資料庫。