用户 'VICENT-2FYIRNRU\ASPNET' 登录失败
rows 35
我家没网络,我是固定IP的,IIS中的IP地址为:(全部未分配)
我连接Access能连接上,我在sql server 2000中的登录中新建了test用户,给了它访问pubs的权利
public void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页; string strConn="Provider=SQLOLEDB;Data Source=localhost;uid=test;pwd=123456;Integrated Security=SSPI;Initial Catalog=pubs ";
string strSel="Select * From authors";
DataSet ds=new DataSet();
//SqlConnection MyConn=new SqlConnection(strConn);
OleDbConnection MyConn=new OleDbConnection(strConn);
//SqlDataAdapter MyAdapter=new SqlDataAdapter(strSel,MyConn);
MyConn.Open(); //35
OleDbDataAdapter MyAdapter=new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"authors");
DataGrid1.DataSource=ds.Tables["authors"].DefaultView;
DataGrid1.DataBind();
}
rows 35
我家没网络,我是固定IP的,IIS中的IP地址为:(全部未分配)
我连接Access能连接上,我在sql server 2000中的登录中新建了test用户,给了它访问pubs的权利
public void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页; string strConn="Provider=SQLOLEDB;Data Source=localhost;uid=test;pwd=123456;Integrated Security=SSPI;Initial Catalog=pubs ";
string strSel="Select * From authors";
DataSet ds=new DataSet();
//SqlConnection MyConn=new SqlConnection(strConn);
OleDbConnection MyConn=new OleDbConnection(strConn);
//SqlDataAdapter MyAdapter=new SqlDataAdapter(strSel,MyConn);
MyConn.Open(); //35
OleDbDataAdapter MyAdapter=new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"authors");
DataGrid1.DataSource=ds.Tables["authors"].DefaultView;
DataGrid1.DataBind();
}
strConn="Provider=SQLOLEDB;Data Source=localhost;uid=test;pwd=123456;Initial Catalog=pubs ";