Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
|
General .NET For general discussion of MICROSOFT .NET topics that don't fall within any of the other .NET forum subcategories or .NET language forums.  If your question is specific to a language (C# or Visual Basic) or type of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without having to ask.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the General .NET 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 April 15th, 2004, 01:10 PM
Registered User
 
Join Date: Apr 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ThePhile C# Downloaded code

Hi,
   I have puchased the book,
Book Name : ASP.NET Website Programming (Problem - Design - Solution) by Marco Bellinaso and Kevin Hoffman

PROBLEM-
    I have downloaded the complete code for the "ThePhile" C# project as explained in the Book. I followed the instructions given in the readme file and FAQs to make the Code up and running. I had several Issues and i solved some of them and i am struck with one Issue. I have modified the Server Name in all the config files and set the SQL server authentication to SQL server and Windows.


ISSUE -

Page Error

--------------------------------------------------------------------------------
An unexpected error has occurred on this page. The system administrators have been notified. Please feel free to contact us with the information surrounding this error.
The error occurred in: http://localhost/ThePhile/Default.aspx
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.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) 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()


Can someone help me out to solve this problem.

Thanks in advance,
arun


 
Old April 15th, 2004, 01:53 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

What version of SQL Server did you install? If you installed the MSDE, or installed a second instance of SQL Server, did you refer to server using ServerName\InstanceName? What's the name of the server?

Doe the account you use in your connection string exists and has access to the required database?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: How High by Tricky (Track 6 from the album: Vulnerable)

 
Old April 16th, 2004, 12:24 AM
Registered User
 
Join Date: Apr 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
  Thanks a lot for the reply

    My server Name is GANESH
    How can i find my Instance Name? what is NetSDK?

This is the connection string i used

<ConnectionString>server=GANESH\NetSDK;database=Th ePhile;uid=sa;pwd=;
</ConnectionString>

Thanks in advance
arun

 
Old April 16th, 2004, 03:02 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

If you installed the MSDE as part of a NET SDK installation, it creates a ServerName\NetSDK instance by default.

Named instances is a new concept of SQL Server that allows multiple instances of SQL Server to coexist on the same physical machine.

Probably the easiest way to find out the instance name is to look here:

C:\Program Files\Microsoft SQL Server

You'll see a folder that starts with MSSQL$. What follows is the name of your MSDE instance.

If you don't see that folder, but have SQL Server installed anyway, try dropping the instance name from your connectionstring e.g.:

<ConnectionString>server=GANESH;database=ThePhile; uid=sa;pwd=;
</ConnectionString>

If you have the SQL Server Enterprise Manager installed, you can look at the Properties dialog for your server. The name, and if applicable the instance name, is displayed on the General tab.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Wait for God by Tricky (Track 10 from the album: Vulnerable)





Similar Threads
Thread Thread Starter Forum Replies Last Post
downloaded code Joseph BOOK: Beginning SQL 5 December 23rd, 2007 09:35 PM
can't understand this code I downloaded am6019a VB How-To 1 July 7th, 2006 09:11 AM
error in downloaded code hertendreef BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 April 9th, 2006 04:56 AM
Downloaded code not Working!!!!!!!!! avats Wrox Book Feedback 3 April 13th, 2005 01:16 PM
Problem with downloaded code Jags ADO.NET 1 April 10th, 2005 03:56 PM





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