net中针对各种数据库的连接字符串

1、sqlserver2000

<connectionString="server=.;database=数据库名;uid=sa;pwd=;Persist Security Info=true" providerName="System.Data.SqlClient"/>

2、sqlserver2005

<connectionString="Data Source=.\SQLEXPRESS;InitialCatalog=库文件地址;User ID=sa;Password=密码;Persist Security Info=true" ProviderName="System.Data.SqlClient"/>

3、Access

<connectionString="Provider=Microsoft.jet.oledb.4.0;Data Source=库文件地址"/>

4、oracle

<connectionString="Data Source=数据库名;User ID=用户名;Password=密码;Persist Security Info=true" providerName="System.Data.OracleClient"/>

转载于:https://www.cnblogs.com/quanwei/archive/2009/07/15/1523894.html