Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 15th, 2004, 01:10 PM
Registered User
 
Join Date: Apr 2004
Location: , , .
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


Reply With Quote
  #2 (permalink)  
Old April 15th, 2004, 01:53 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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)

Reply With Quote
  #3 (permalink)  
Old April 16th, 2004, 12:24 AM
Registered User
 
Join Date: Apr 2004
Location: , , .
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

Reply With Quote
  #4 (permalink)  
Old April 16th, 2004, 03:02 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 04:11 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.