使用dsn的數據庫連接字符串例:
ms sql / mysql / postgresql
dsn=dsnname
不使用dsn數據庫連接字符串例:
ms access
通過oledb:
provider=microsoft.jet.oledb.4.0; data source=c:somepathmydb.mdb;
ms sql
通過odbc:
driver={sql server}; server=myservername; database=mydatabasename; uid=myusername; pwd=mypassword
with oledb (recommended):
provider=sqloledb; data source=myservername; initial catalog=mydatabasename; user id=myusername; password=mypassword
mysql
通過odbc:
driver={mysql odbc 3.51 driver}; server=servername; database=dbname; uid=username; pwd=password; option=3
postgresql
通過odbc:
driver={postgresql}; server=servername; database=dbname; uid=username; pwd=password
對於ms access數據庫來說，因為access數據庫的odbc驅動程序會導致不穩定，所以最好不要通過dsn來連接。