Error Trying to Launch Project

From: glynch (glynch_at_discussions.microsoft.com)
Date: 08/20/04

Next message: Harry Simpson: "Cache 22"

Previous message: Dendarii.fm: "Local Web Service problem in VS.Net 2003 Pro"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 20 Aug 2004 05:03:02 -0700

I am new to vb.net and I found some pretty good instructions on how to set up
and run a project for a web application by using the walk-through at this
website:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vbwlkCreatingDistributedWebApplicationWalkthrough.asp

Everything seemed fine until the last step when I actually tried to run the
application. I followed the instructions very carefully (I actually did it
twice), both times with the same error message.

I have 7 years of programming experience including a fair amount of VB and
SQL Server, but this is my first experience with .Net. I am using a SQL
Server and the pubs database just like the instructions told me to. I have
played around a little bit with the SQLConnection properties, trying to use a
different login id as well as using sa, all to the same result.

I am using Visual Studio.Net 2003 and SQL Server 2000.

Any help would be appreciated.

Thanks, Gerry

Here is the error I receive:

Server Error in '/AuthorsWebClient1' Application.
--------------------------------------------------------------------------------

System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> System.Data.SqlClient.SqlException: Login failed for user
'glynch'. 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
AuthorsWebService.AuthorsService.GetAuthors() in
c:\inetpub\wwwroot\AuthorsWebService\AuthorsService.asmx.vb:line 125 --- End
of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> System.Data.SqlClient.SqlException: Login failed for user
'glynch'. 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
AuthorsWebService.AuthorsService.GetAuthors() in
c:\inetpub\wwwroot\AuthorsWebService\AuthorsService.asmx.vb:line 125 --- End
of inner exception stack trace ---

Source Error:

Line 43:
<System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/AuthorsWebService/Service1/GetAuthors",
RequestNamespace:="http://tempuri.org/AuthorsWebService/Service1",
ResponseNamespace:="http://tempuri.org/AuthorsWebService/Service1",
Use:=System.Web.Services.Description.SoapBindingUse.Literal,
ParameterStyle:=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)> _
Line 44: Public Function GetAuthors() As authors1
Line 45: Dim results() As Object = Me.Invoke("GetAuthors", New
Object(-1) {})
Line 46: Return CType(results(0),authors1)
Line 47: End Function

Source File: c:\inetpub\wwwroot\AuthorsWebClient1\Web
References\localhost\Reference.vb Line: 45

Stack Trace:

[SoapException: System.Web.Services.Protocols.SoapException: Server was
unable to process request. ---> System.Data.SqlClient.SqlException: Login
failed for user 'glynch'.
   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 AuthorsWebService.AuthorsService.GetAuthors() in
c:\inetpub\wwwroot\AuthorsWebService\AuthorsService.asmx.vb:line 125
   --- End of inner exception stack trace ---]

System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) +1488
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +218
   AuthorsWebClient1.localhost.AuthorsService.GetAuthors() in
c:\inetpub\wwwroot\AuthorsWebClient1\Web References\localhost\Reference.vb:45
   AuthorsWebClient1.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\AuthorsWebClient1\WebForm1.aspx.vb:38
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +731

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573

Next message: Harry Simpson: "Cache 22"

Previous message: Dendarii.fm: "Local Web Service problem in VS.Net 2003 Pro"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Cannot define the DataMember in code
... Private WithEvents cmInsertAuthor As New SqlCommand ... Int32 startRecord, Int32 maxRecords, String ... srcTable, IDbCommand command, CommandBehavior behavior) ...
(microsoft.public.dotnet.framework.adonet)
Re: Data access error
... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ... srcTable, IDbCommand command, CommandBehavior behavior) ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ...
(microsoft.public.dotnet.framework.aspnet)
ThreadAbortException at System.Data.SqlClient.SqlCommand.ExecuteRe (BIS)
... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... CommandBehavior behavior) ...
(microsoft.public.dotnet.framework.adonet)
datagrid error
... Server]Line 1: Incorrect syntax near '.'.] ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... CommandBehavior behavior) +77 ...
(microsoft.public.dotnet.framework.aspnet)
ThreadAbortException at System.Data.SqlClient.SqlCommand.ExecuteRe
... When i launch the same code sometimes it never crash a the same place but ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... CommandBehavior behavior) ...
(microsoft.public.dotnet.framework.adonet)