我以前连接的是Access数据库,使用的是OleDB模式连接的数据库,现在需要该,想连SQL数据库,可是试了半天就是不会,不知该怎么做。我以前在Web.config中写是
“<add key="strConnection"value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\shuju\database\Mydatabase.mdb" />”能连接,能不能只是该Web.config中改一下,就可以的。我试了一个不行。<add key = "strConnection" value="provider=MSDASQL = {SQLServer};{server=127.0.0.1;uid=sa;pwd=;database=Data}" /> 错误说是: 不支持ODC模式。还有一个是:<add key = "strConnection" value="provider=Microsoft.Jet.OLEDB.4.0 = {SQLServer};{server=127.0.0.1;uid=sa;pwd=;database=Data}" />错误说是: 找不到SIM。
“<add key="strConnection"value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\shuju\database\Mydatabase.mdb" />”能连接,能不能只是该Web.config中改一下,就可以的。我试了一个不行。<add key = "strConnection" value="provider=MSDASQL = {SQLServer};{server=127.0.0.1;uid=sa;pwd=;database=Data}" /> 错误说是: 不支持ODC模式。还有一个是:<add key = "strConnection" value="provider=Microsoft.Jet.OLEDB.4.0 = {SQLServer};{server=127.0.0.1;uid=sa;pwd=;database=Data}" />错误说是: 找不到SIM。
测试成功的各种连接字符串:ConnectionStringmyConnectionString="Initial Catalog=Northwind;"+"Data Source=PENTIUM4;user id=sa;password=;Connect Timeout=20";myConnectionString="workstation id=PENTIUM4;packet size=4096;integrated security=SSPI;data source=PENTIUM4;persist security info=False;initial catalog=Northwind";SqlConnection myConn=new SqlConnection(@"server=PENTIUM4;uid=sa;pwd=;database=Info;");SqlConnection myConn=new SqlConnection(@"server=PENTIUM4;user id=sa;password=;database=Info;");
谢谢大侠们多多帮忙。
{
string str ="Password=;User ID= sa;Data Source=.; initial catalog=Data";
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(str);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.Connection=con;
cmd.CommandText="select 'Test' as T";
con.Open();
this.DataGrid1.DataSource = cmd.ExecuteReader();
this.DataGrid1.DataBind();
con.Close();
}
<!--<add key="data" value="data source=210.192.124.248;initial catalog=insintekcrm;persist security info=False;user id=sa;password=;workstation id=WUFENG;packet size=4096"></add>
-->
<add key="data" value="server=210.192.124.248;uid=insintek;pwd=insintek;"></add>
</appSettings>
这两种试试