我的数据库是个人版的sqlserver2000,asp程序可以访问数据库,但改成asp.net就访问出错了.请教原因.
连接串:
asp:-------------------------------------
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=SQLOLEDB.1;User ID=sa;password=zskqkq;Initial Catalog=kq_test;Data Source=22.140.192.39;Connect Timeout=120"
conn.Open connstrasp.net:------------------------------------- Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
'在此处放置初始化页的用户代码
strSql = "SELECT * FROM tlr_tbl"
ConnStr = "provider=SQLOLEDB.1;User ID=sa;Password=zskqkq;Initial Catalog=pf_database;Data Source=22.140.192.39;Connect Timeout=300" myConnection = New oledbConnection(ConnStr)
myConnection.Open()
mydtadp = New oledbDataAdapter(strSql,myConnection)
mydtadp.Fill(myds, "a")
DataGrid1.CurrentPageIndex=1
DataGrid1.DataSource = myds
DataGrid1.databind() End Sub
连接串:
asp:-------------------------------------
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=SQLOLEDB.1;User ID=sa;password=zskqkq;Initial Catalog=kq_test;Data Source=22.140.192.39;Connect Timeout=120"
conn.Open connstrasp.net:------------------------------------- Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
'在此处放置初始化页的用户代码
strSql = "SELECT * FROM tlr_tbl"
ConnStr = "provider=SQLOLEDB.1;User ID=sa;Password=zskqkq;Initial Catalog=pf_database;Data Source=22.140.192.39;Connect Timeout=300" myConnection = New oledbConnection(ConnStr)
myConnection.Open()
mydtadp = New oledbDataAdapter(strSql,myConnection)
mydtadp.Fill(myds, "a")
DataGrid1.CurrentPageIndex=1
DataGrid1.DataSource = myds
DataGrid1.databind() End Sub
ASP和ASP.NET使用的连接服务是不一样的找MSDN,调一下provider=SQLOLEDB.1这部分会有奇效
provider=后面写成"."或者是"localhost"。
webconfig配置文件内容:
<add key="Connection" value="Server=.;database=Oa_Test;uid=sa;pwd=sa"/>
"Data Source=192.168.18.10;database=dataDB;uid=sa;pwd=12345"
所以你要修改
ConnStr = "Uid =sa;pwd=zskqkq;database=pf_database;Data Source=22.140.192.39;Connect Timeout=300"