Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution 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
 
Old July 30th, 2003, 03:28 PM
Authorized User
 
Join Date: Jul 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to brettdavis4
Default Error Message: SQL Server does not exist or access

I am having problems with this book. I keep getting the following error,

Error Message: SQL Server does not exist or access denied.

Stack Trace:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.SqlConnection.Open() at Wrox.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, Int32& rowsAffected) in C:\wrox\ThePhile\Modules\Core\DbObject.cs:line 104 at Wrox.WebModules.Polls.Data.Questions.GetCurrentID( ) in C:\wrox\ThePhile\Modules\Polls2\Polls.Data\Questio ns.cs:line 94 at Wrox.WebModules.Polls.Business.Question.GetCurrent ID() in C:\wrox\ThePhile\Modules\Polls2\Polls.Business\Que stion.cs:line 129 at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 123 at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 114 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain()

I have tried playing around with the web.config and I still get the same error. Can anybody tell me what I am doing wrong?

Thanks,

Brett Davis

 
Old July 31st, 2003, 02:33 AM
Friend of Wrox
 
Join Date: May 2003
Posts: 229
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Brett,

I think you have not changed the connection string in various config files residing the config folder as described in the readme file.

Charul Shukla

 
Old August 1st, 2003, 09:12 PM
Authorized User
 
Join Date: Jul 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to brettdavis4
Default

Charul,

You are right I didn't follow all of the directions.

Brett

 
Old August 1st, 2003, 10:34 PM
Registered User
 
Join Date: Aug 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Anyone know how to fix this problem, or at least a website that can help me guide through it

Thnaks

 
Old August 2nd, 2003, 02:49 AM
Friend of Wrox
 
Join Date: May 2003
Posts: 229
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by callmeshort
 Anyone know how to fix this problem, or at least a website that can help me guide through it

Thnaks

Please tell me what excatly your problem is , then only i am able to sort out the matter with best my efforts

 
Old August 2nd, 2003, 08:17 AM
Registered User
 
Join Date: Aug 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I get the following error message when in my ASPX application:

"System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.SqlConnection.Open() at "

 
Old August 3rd, 2003, 06:31 AM
Friend of Wrox
 
Join Date: May 2003
Posts: 229
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by callmeshort
 I get the following error message when in my ASPX application:

"System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.SqlConnection.Open() at "

Hi, i think you have the same problem brett is facing. You need to change the SQL server name in web.config file and also all the config files residing in the config folder.








Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server does not exist or access denied jennypretty Classic ASP Databases 3 May 18th, 2007 11:43 AM
SQL Server does not exist or access denied jmjyiannis VB.NET 2002/2003 Basics 1 July 26th, 2005 09:06 AM
SQL Server does not exist or access denied haidee_mccaffrey Classic ASP Databases 19 June 28th, 2004 09:38 PM
Error:SQL Server does not exist or access denied. riga SQL Server ASP 2 June 11th, 2004 10:26 PM
Error Message: SQL Server does not exist or access danielboland SQL Server 2000 1 January 19th, 2004 01:28 PM





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