SQl exeption

Question

Post reply

SQl exeption

nirmala-220291

Newbie

Points: 8
More actions
August 22, 2005 at 11:34 am

#87319

Help needed
We are having Ecommerce website in Windows 2000,SQL Server 2000 and Commerce server 2002.
which was working fine in production. off late we are running into problems some are sql exception.
We received the following exception
Stack Trace: System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation.
   at Microsoft.CommerceServer.Site.Payment.btnPurchase_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain()
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain()
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at System.Web.CallHandlerExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
We receive this error when a customer try to submit a payment.
appreciate your help..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

What happens if you rerun the statement in the same context but from query analyser (to get the actual server error).

peterhe SSChampion Points: 11469 More actions · Answer 2

When the server or connection is not available, you will have this "General network error".

If you can ping the server from the client, you can check the connection string (server name, db name, user and pass), sql server authentication method etc. If you using windows authentication, make sure the windows account has permission.