用户登录:
<add name="DefaultConnectionString1" providerName="System.Data.SqlClient" connectionString="server=192.168.0.x\SQLEXPRESS2008R2;database=BOS;uid=sa;pwd=12345"/>
windows帐户登录:
<add name="DefaultConnectionString2" providerName="System.Data.SqlClient" connectionString="server=localhost\SQLEXPRESS;Integrated Security=SSPI;database=BOS"/>
'Access 2000的連接
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "/North.mdb;Persist Security Info=False"
'SQL Server2000的連接
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=develop; password=12345;Data Source=ServerName"