《各种连接数据库字符串》由会员分享，可在线阅读，更多相关《各种连接数据库字符串（3页珍藏版）》请在装配图网上搜索。
1、System.Data.SqlClient.SqlConnection常用的一些连接字符串(C#代码)：SqlConnertion con=new SqlConnection(Server=(local);Integrated Security=SSPI;database=Mydata);SqlConnertion con=new SqlConnection(server=(local);database=Mydata;Integrated Security=SSPI);SqlConnection con=new SqlConnection(Data Source=localhost;Inte
2、grated Security=SSPI;Initial Catalog=Mydata;);SqlConnection con=new SqlConnection(data source=127.0.0.1;initial catalog=Mydata;intergrated security=SSPI;persist security info=False;workstation id=127.0.0.1;packet size=4096;);SqlConnection con=new SqlConnection(Persist Security Info=False;Intergrated
3、 Security=SSPI;database=Mydata;server=.);SqlConnection con=new SqlConnection(uid=sa;pwd=123456;initial catalog=Mydata;data source=.;Connect Timeout=900);生词:Initial Catalog workstation id packet size Persist Security InfoInitial catalog: 要连接的数据库名称 （还有database）Workstation id:标识计算机名或IP地址(二database即可用计算
4、机名、IP地址又可以用数据库名称)packet size:网络数据包大小Persist Security Info:可以简单理解为登陆以后是否保存密码信息 true为保存 false为不保存System.Data.OleDb.OleDbConnection常用的一些连接字符串(C#代码)：OleDbConnection con=new OleDbConnection(provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:Mydata.mdb);OleDbConnection con=new OleDbConnection(Provider=Microso
5、ft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=Mydata.mdb;);OleDbConnection con=new OLeDbConnection(Provider=MSDAORA;Data Source=ORACLE8i7;Persist Security Info=False;Intergrated Security=yes);OleDbConnection con=new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:Mydata.mdb);Ol
6、eDbConnection con=new OleDbConnection(Provider=SQLOLEDB;Data Source=127.0.0.1;Integrated Security=SSPI);生词:ProviderProvider:供应商 System.Data.Odbc.OdbcConnection常用的一些连接字符串(C#代码)：OdbcConnection con=new OdbcConnection(Driver=SQL Server;Server=127.0.0.1;Trusted_Connection=yes;Database=Mydata);OdbcConnect
7、ion con=new OdbcConnection(Driver=Microsoft ODBC for Oracle;Server=ORACLE8i7; persist Security Info=False;Trusted_Connection=yes);OdbcConnection con=new OdbcConnection(Driver=Microsoft Access Driver (*.mdb);DBQ=D:Mydata.mdb);OdbcConnection con=new OdbcConnection(Driver=Microsoft Excel Driver (*.xls);DBQ=D:Mydata.xls);OdbcConnection con=new OdbcConnection(Driver=Microsoft Text Driver (*.txt;*.csv);DBQ=D:Mydata);OdbcConnection con=new OdbcConnection(DSN=dsnname);生词: Driver DBQ DSNDriver:驱动DBQ:数据库连接路径DSN:暂时没查到
各种连接数据库字符串
