Wrox Programmer Forums
|
BOOK: ASP.NET 3.5 Website Programming Problem Design Solution
This is the forum to discuss the Wrox book ASP.NET 3.5 Website Programming Problem Design Solution by Chris Love; ISBN: 978-0-470-18758-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 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 December 4th, 2009, 08:45 AM
Authorized User
 
Join Date: Jul 2008
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Default Application Solution Does not Run

Hi,

I opened the solution and ran the debugger. The code failed, as can be seen in this screenshot: http://i167.photobucket.com/albums/u...SharpError.png

The error message is :
Quote:
"Cannot open database \"TheBeerHouseVB\" requested by the login. The login failed.\r\nLogin failed for user 'GARTH\\dave'."
The ConnectionString in the config file looked a bit weird:
Quote:
connectionString="metadata=res://*;provider=System.Data.SqlClient;provider connection string="Data Source=.;Initial Catalog=TheBeerHouseVB;Integrated Security=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
I also noted that the solution was trying to connect to source control when I first opened it. Not cool.

Does anyone know how I can get this to work?
 
Old December 6th, 2009, 01:04 AM
Registered User
 
Join Date: Dec 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You need to change the datasource and/or database name to match what you've linked the database in as.

Data Source=.;

means localhost with an unnamed Sql Server instance (default installation)

Initial Catalog=TheBeerHouseVB

is the name you've restored the database with
 
Old December 6th, 2009, 01:19 AM
Authorized User
 
Join Date: Jul 2008
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks Hamish. I got that working.

But check out these screen shots:
http://www.box.net/shared/hezqvd73p8
http://www.box.net/shared/813vensm3e

The same result in Opera too.

Perhaps the author fixes those blemishes later in the book. But I thought the download code would be the finished product. That is some embarrassing CSS work.
 
Old December 6th, 2009, 02:18 AM
Registered User
 
Join Date: Dec 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I understand that the C# code is in worse shape than the VB code.
You might want to download the VB and see how it goes

I get it to list the categories for articles but if you click on one it doesn't link through correctly.
 
Old December 6th, 2009, 03:34 AM
Authorized User
 
Join Date: Jul 2008
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Default

Yeah. The CSS layout worked in the VB version.

On a side-note, I was very disappointed that this book was written in VB. I pre-ordered it very early, believeing it would be an updated version of the last excellent Beerhouse book by Marco. Bummed out.

If the author gets in and rectifies these errors, I'll be satisfied. But if he shows no interest, then I guess I'll have to fix them myself, when I get a chance. And I won't have a high opinion of the author. I'm used to cleaning up other people's messes. It's part of my job.
 
Old December 10th, 2009, 07:29 AM
Authorized User
 
Join Date: Jul 2008
Posts: 29
Thanks: 0
Thanked 2 Times in 2 Posts
Send a message via MSN to docluv
Default

Code is routinely updated on Code Plex, http://thebeerhouse.codeplex.com/Sou...leCommits.aspx
__________________
http://Professionalaspnet.com
 
Old December 11th, 2009, 07:02 PM
Authorized User
 
Join Date: Jul 2008
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Default

I downloaded the latest code. It does not compile.
Here's some of the many errors:

Error 12 The type or namespace name 'BLL' could not be found (are you missing a using directive or an assembly reference?) D:\dave\books\ASP.NET 3.5 Website Programming\TheBeerHouse_35_CS\BeerHouse35\App_Cod e\GetNewsLetterStatus.cs 4 7 D:\...\BeerHouse35\

Error 13 The type or namespace name 'TheBeerHouse' could not be found (are you missing a using directive or an assembly reference?) D:\dave\books\ASP.NET 3.5 Website Programming\TheBeerHouse_35_CS\BeerHouse35\App_Cod e\CommentService.cs 4 7 D:\...\BeerHouse35\

Error 1 The type or namespace name 'TwitterLib' could not be found (are you missing a using directive or an assembly reference?) D:\dave\books\ASP.NET 3.5 Website Programming\TheBeerHouse_35_CS\TBHBLL\Articles\Art icle.cs 1 7 TBHBLL
 
Old December 13th, 2009, 09:34 PM
Authorized User
 
Join Date: Jul 2008
Posts: 29
Thanks: 0
Thanked 2 Times in 2 Posts
Send a message via MSN to docluv
Default

I don't think you opened the solution, I think you opened the website project. You should have a solution with the website and the BLL. plus there should be dlls for the 3rd party libraries like the twitter library.
__________________
http://Professionalaspnet.com
 
Old December 17th, 2009, 06:06 AM
Authorized User
 
Join Date: Jul 2008
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Default

I did load the whole solution - the sln file which sits above the two project directories. So both projects were opened in VS.

I had a quick look in the bin folder of the website folder and can confirm that the twitter library is in there.

So something has gone a bit wonky with the environment, as I still get those error messages.
 
Old December 17th, 2009, 08:47 AM
Authorized User
 
Join Date: Jul 2008
Posts: 29
Thanks: 0
Thanked 2 Times in 2 Posts
Send a message via MSN to docluv
Default

What version (edition) of Visual Studio are you working with? Does your reference to the TwitterLib point to the .dll in the 3rd Party folder correctly?
__________________
http://Professionalaspnet.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
General solution to handle web application errors? woojtii Internet Information Services 1 March 27th, 2007 08:42 AM
run application more than once!!!! angelboy C# 2005 2 February 12th, 2007 03:53 PM
run application without .NetFramework !!!!! angelboy C# 2005 2 January 17th, 2007 04:24 PM
Not able to run my application twice! nicky05 Excel VBA 0 August 26th, 2005 04:44 AM
automatic run of an application deb_prgmr Visual Basic 2005 Basics 0 December 20th, 2004 09:37 AM





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