| 資料庫 | 連線字串 |
| Access (Jet OLEDB) | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\db.mdb;Jet OLEDB:Database Password=pwd; |
| Access (ACE OLEDB 16.0) | Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\path\db.accdb; |
| Access (ODBC) | Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\db.mdb; |
| SQL Server (MSOLEDBSQL) | Provider=MSOLEDBSQL;Server=ip;Database=db;UID=user;PWD=pwd;Encrypt=yes;TrustServerCertificate=yes; |
| SQL Server (ODBC 17/18) | Driver={ODBC Driver 17 for SQL Server};Server=ip;Database=db;UID=user;PWD=pwd; |
| Oracle (OLEDB) | Provider=OraOLEDB.Oracle;Data Source=ORCL;User Id=user;Password=pwd; |
| Oracle (ODBC) | Driver={Oracle in OraClient12Home1};DBQ=ORCL;UID=user;PWD=pwd; |
| MySQL (ODBC 8.0 Unicode) | Driver={MySQL ODBC 8.0 Unicode Driver};Server=127.0.0.1;Port=3306;Database=db;UID=user;PWD=pwd;Charset=utf8mb4; |
| Visual FoxPro | Provider=VFPOLEDB.1;Data Source=C:\path\db.dbc; |
| Text/CSV (ODBC) | Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=C:\folder\;Extensions=txt,csv;Persist Security Info=False; |
| Text/CSV (Jet OLEDB) | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\folder\;Extended Properties="text;HDR=Yes;FMT=Delimited"; |