Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 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 October 15th, 2006, 06:53 PM
Registered User
 
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Server Error in '/OnlineDiary' Application.

I am having a problem running the downloads.
Each time I try running any of the applications it generates an error.
Please help me out.

Server Error in '/OnlineDiary' Application.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
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: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

Source Error:

Line 214: sqlCmd.Parameters.AddWithValue("@DiaryId", DiaryId)
Line 215:
Line 216: diaryDBConn.Open()
Line 217: Dim entrySQLDR As SqlDataReader = sqlCmd.ExecuteReader(CommandBehavior.CloseConnecti on)
Line 218: sqlCmd = Nothing


Source File: D:\Documents and Settings\Administrator\My Documents\Mybooks\OnlineDiary\App_Code\DiaryEntry. vb Line: 216

 
Old October 16th, 2006, 01:38 AM
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,

Did you change the security settings for the App_Code folder? Your webserver account (either you, or ASPNET or Network Service) needs write permissions to this folder.

And how is your SQL Server installation called? Is it called SqlExpress or does it have a different name?

Also, try moving the site to something like c:\Inetpub\wwwroot\MyBooks.

It'll be easier to configure the site from there.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
 
Old October 16th, 2006, 02:24 AM
Registered User
 
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar,
I moved the directory to D:\Inetpub\wwwroot.
I also enabled write permission for the App_code folder and the App_data folder.
But I still get the same Error.
I also noticed that when I type localhost/Onlinediary the browser returns

Directory Listing Denied
This Virtual Directory does not allow contents to be listed.
The SQLserver express came installed with VS 2005 Professional.
It is called SQLEXPRESS.

 
Old October 16th, 2006, 10:07 AM
Registered User
 
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks
I already got the files running.


 
Old October 16th, 2006, 03:29 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,

Glad it's working now. For the benefit of the archive, would you mind sharing how you fixed it?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Server Error in '/' Application. workidoo ASP.NET 3.5 Professionals 6 January 7th, 2009 04:19 PM
Getting error in OnlineDiary application rsexton BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 June 4th, 2007 03:25 AM
Server Error in '/' Application. abhishekkashyap27 ASP.NET 1.0 and 1.1 Basics 2 May 20th, 2007 12:35 AM





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