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