举例如下,一种不行用另一种 string str ="server=workflow;uid=sa;pwd=workflow123;database=Northwind";Web.config for an ASP.NET Web application: <configuration> <appSettings> <add key="DBConnStr" value="server=(local);Integrated Security=SSPI;database=northwind"/> </appSettings> </configuration>
connstring ="Auto Translate=True;User ID=sa;Data Source=192.168.160.88;Password=‘’;Initial Catalog=pubs;Use Procedure for Prepare=1;Provider=SQLOLEDB.1; Workstation ID=192.168.160.88"/>
@"security=sspi;database=database_name";
SqlConnection conn=new SqlConnection(conn_str);
...//////////////
注意:server就是你机器的主机名,如果不知道自己主机名的话可以用:
using System.Net.Sockets;
using System.Net;
...
string hostname=Dns.GetHostName(); //获取本地主机名
...
wish u good luck
Greatsft
string str ="server=workflow;uid=sa;pwd=workflow123;database=Northwind";Web.config for an ASP.NET Web application: <configuration>
<appSettings>
<add key="DBConnStr" value="server=(local);Integrated Security=SSPI;database=northwind"/>
</appSettings>
</configuration>