適用於通用 ODBC 驅動程式,跨語言、跨平台相容性佳。
| 資料庫 | 連線字串範本 |
|---|---|
| Access | Driver={Microsoft Access Driver (*.mdb)};Dbq=path\to\file.mdb;Uid=admin;Pwd=pass; |
| dBase | Driver={Microsoft dBase Driver (*.dbf)};DriverID=277;Dbq=path\to\folder; |
| Oracle | Driver={Microsoft ODBC for Oracle};Server=oracle_svc_name;Uid=admin;Pwd=pass; |
| SQL Server | Driver={SQL Server};Server=server_name;Database=db_name;Uid=sa;Pwd=pass; |
| Text/CSV | Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=path\to\folder;Extensions=asc,csv,tab,txt;Persist Security Info=False; |
| Visual FoxPro | Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=path\to\file.dbc;Exclusive=No; |
| MySQL | Driver={MySQL ODBC 8.0 Driver};Database=db_name;Uid=user;Pwd=pass;Option=16386; |
| SQLite | Driver={SQLite3 ODBC Driver};Database=D:\path\to\file.db |
| PostgreSQL | Driver={PostgreSQL ANSI};Server=127.0.0.1;Uid=admin;Pwd=pass;Database=db_name |
Windows 原生高效能提供者,適合 .NET / ADO / VB6 等環境。
| 資料庫 | 連線字串範本 |
|---|---|
| Access (Jet 4.0) | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\to\file.mdb;User ID=admin;Password=pass; |
| Access (ACE 12.0+) | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path\to\file.accdb;Persist Security Info=False; |
| Oracle | Provider=OraOLEDB.Oracle;Data Source=tns_name;User ID=admin;Password=pass; |
| SQL Server | Provider=SQLOLEDB;Data Source=server_name;Initial Catalog=db_name;User ID=sa;Password=pass; |
| SQL Server (Native Client) | Provider=SQLNCLI11;Data Source=server_name;Initial Catalog=db_name;User ID=sa;Password=pass; |
| Text/CSV | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\to\folder;Extended Properties="Text;HDR=YES;FMT=Delimited" |
%windir%\System32\odbcad32.exe (64-bit) 與 %windir%\SysWOW64\odbcad32.exe (32-bit) 管理工具。Pwd='pa;ss=word'。Connection Timeout=30;Encrypt=Yes;TrustServerCertificate=No; 等參數。test.udl 檔案(空文字檔改副檔名),雙擊開啟「資料連結屬性」視窗圖形化測試 OLEDB。odbcad32.exe 建立系統/使用者 DSN 測試。SqlException, OleDbException)。收藏此速查表,下次連線資料庫不再東拼西湊。記住:驅動版本對齊、位元數匹配、特殊字元轉義 是避坑三要素。