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"/>

posted @ 2009-07-15 10:45  淘金者  阅读(255)  评论(1)  编辑  收藏  举报