Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 22nd, 2011, 03:27 AM
Registered User
 
Join Date: Apr 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default A network-related or instance-specific error - IExecuteResult result

Hi,

Most of the application works fine. Its just that when I try to

Home ->View My Requests -> "Make Another Request", -> as soon as I click the Save button, I get the following error. Most other database operations workfine.

Could anyone please advice?


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:


Line 1525: public ISingleResult<ENTAuditObject> ENTAuditObjectSelectByObjectName([Parameter(Name="ObjectName", DbType="VarChar(255)")] string objectName)
Line 1526: {
Line 1527: IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), objectName);
Line 1528: return ((ISingleResult<ENTAuditObject>)(result.ReturnValu e));
Line 1529: }


Source File: C:\university\PaidTimeOffSolution\V2.PaidTimeOffDA L\HRPaidTimeOff.designer.cs Line: 1527

Stack Trace:


[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4860189
System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Linq.SqlClient.SqlConnectionManager.Us eConnection(IConnectionUser user) +44
System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe () +45
System.Data.Linq.SqlClient.SqlProvider.InitializeP roviderMode() +20
System.Data.Linq.SqlClient.SqlProvider.System.Data .Linq.Provider.IProvider.Execute(Expression query) +57
System.Data.Linq.DataContext.ExecuteMethodCall(Obj ect instance, MethodInfo methodInfo, Object[] parameters) +69
V2.PaidTimeOffDAL.HRPaidTimeOffDataContext.ENTAudi tObjectSelectByObjectName(String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffDA L\HRPaidTimeOff.designer.cs:1527
V2.PaidTimeOffDAL.Framework.ENTAuditObjectData.Sel ect(HRPaidTimeOffDataContext db, String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffDA L\Framework\ENTAuditObjectData.cs:77
V2.PaidTimeOffBLL.Framework.ENTAuditObjectEO.Load( HRPaidTimeOffDataContext db, String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\Framework\ENTAuditObjectEO.cs:155
V2.PaidTimeOffBLL.Framework.ENTAuditObjectEO.Load( String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\Framework\ENTAuditObjectEO.cs:148
V2.PaidTimeOffBLL.Framework.ENTBaseEO.StorePropert yValues() in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\Framework\ENTBaseEO.cs:204
V2.PaidTimeOffBLL.PTORequestEO.Load(Int32 id) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\PTORequestEO.cs:78
PTORequest.Page_Load(Object sender, EventArgs e) in c:\University\SIRSSolution\SIRSUI\PTORequest.aspx. cs:68
System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
BaseEditPage`1.OnLoad(EventArgs e) in c:\University\SIRSSolution\SIRSUI\App_Code\BaseEdi tPage.cs:75
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
  #2 (permalink)  
Old April 23rd, 2011, 03:16 AM
Registered User
 
Join Date: Apr 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Almost Done! Please someone reply to this above post!!!

Almost Done! Please someone reply to this above post!!!


Similar Threads
Thread Thread Starter Forum Replies Last Post
[newbie]network-related or instance-specific error occurred jon80 BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9 1 March 15th, 2009 04:02 PM
[newbie]A network-related or instance-specific error... jon80 BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9 0 March 14th, 2009 07:43 AM
Network related help required... shankhan Internet Information Services 0 September 22nd, 2007 01:34 AM
error related to vb6 Rajesh Pachouri Pro VB 6 0 September 16th, 2006 03:14 AM
getting a specific row from a MySQL result set Tachyon Beginning PHP 3 July 12th, 2004 11:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.