使用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来连接。