测试Web服务出错,请帮忙(在线等待)。
waxx 2003-08-26 10:43:03
[WebMethod]
public DataSet GetPubs()
{
string strConn="Initial Catalog=pubs;Data Source=localhost;Integrated Security=SSPI;";
SqlConnection MyConn=new SqlConnection(strConn);
SqlDataAdapter MyAdapter=new SqlDataAdapter("Select * from authors",MyConn);
DataSet MyDataSet =new DataSet();
MyAdapter.Fill(MyDataSet);// line :63
return MyDataSet;
}
当通过浏览器测试Web服务时,显示错误:
System.Data.SqlClient.SqlException: 用户 'GJP\ASPNET' 登录失败。
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Test1.Service1.GetPubs() in d:\inetpub\wwwroot\test1\service1.asmx.cs:line 63