OleDb连接SQLServer

2016-12-07 20:40:16来源:CSDN作者:lovegonghui人点击

OleDb本地连接SQLServer的连接字符串是:

<appSettings>    <add key="ConnectionString" value="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;PWD=****;Initial Catalog=myDB;Data Source=192.168.4.127,1433" />    </appSettings>

OleDb远程连接SQLServer的连接字符串是:

 <appSettings>       <add key="ConnectionString" value="Provider=sqloledb;Data Source=192.168.4.127,1433;Network Library=DBMSSOCN;Initial Catalog=myDB;User ID=sa;Password=*****;" />  </appSettings>




最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台