不知道哪里错了
我在弄ASP.NET Web服务的时候出现的问题 我想应该很简单，但是我还是不知道怎么改，谢谢高手了！
System.Data.SqlClient.SqlException: SQL Server 不存在或访问被拒绝。
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(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 WebService2.Service1.CustOrder(String CustID, String StratDate, String EndDate) in c:\inetpub\wwwroot\WebService2\Service1.asmx.vb:line 64
[解决办法]
你没有创建SqlConnection对象，没有打开数据库联接
SqlConnection的Open()方法
我不会写vb的
你自己看下msdn library吧
[解决办法]
Public Function CustOrder(ByVal CustID As String, ByVal StratDate As String, ByVal EndDate As String) As DataSet
Dim constr As String
constr = "server=localhost;database=CallCenter11;uid=sa;pwd= "
Dim sqlQry As String
Dim con as SqlConnection;
con=new SqlConnection(constr);
con.Open();
sqlQry = "select * from CustOrder where CustID= ' " + CustID + " 'and Date> = ' " + StratDate + " 'and Date <= ' " + EndDate + " ' "
Dim cmdobj As New SqlDataAdapter(sqlQry, con)
Dim dsobj As New DataSet
cmdobj.Fill(dsobj)
Return dsobj
End Function
[解决办法]
iis里开通了数据库连接了吗?
