Wrox Programmer Forums
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 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 19th, 2011, 08:43 AM
Authorized User
Join Date: Dec 2007
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default Error when trying to load themes


I'm trying to run the chapter 10 version of the web site, but it crashes when it tries to load themes. The error follows:

System.Data.SqlClient.SqlException was unhandled by user code
Message="Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'."
Source=".Net SqlClient Data Provider"
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Util.SecUtility.CheckSchemaVersion(Prov iderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck)
at System.Web.Profile.SqlProfileProvider.CheckSchemaV ersion(SqlConnection connection)
at System.Web.Profile.SqlProfileProvider.GetPropertyV aluesFromDatabase(String userName, SettingsPropertyValueCollection svc)
at System.Web.Profile.SqlProfileProvider.GetPropertyV alues(SettingsContext sc, SettingsPropertyCollection properties)
at System.Configuration.SettingsBase.GetPropertiesFro mProvider(SettingsProvider provider)
at System.Configuration.SettingsBase.GetPropertyValue ByName(String propertyName)
at System.Configuration.SettingsBase.get_Item(String propertyName)
at System.Web.Profile.ProfileBase.GetInternal(String propertyName)
at System.Web.Profile.ProfileBase.get_Item(String propertyName)
at System.Web.Profile.ProfileBase.GetPropertyValue(St ring propertyName)
at ProfileCommon.get_Theme()
at Wrox.Web.GlobalEvents.ThemeModule.app_PreRequestHa ndlerExecute(Object Sender, EventArgs E)
at System.Web.HttpApplication.SyncEventExecutionStep. System.Web.HttpApplication.IExecutionStep.Execute( )
at System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously)

Here is the code:
PublicOverridableProperty Theme() AsString
Me.SetPropertyValue("Theme", value)
[/ code]

It is from C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\9ff55a9a\71ce5fa6\App_Code.t2zhwy bw.7.vb

This is right out of the 'box'. Can someone tell be how to work around this?

Thomas G Magaro

Last edited by flashmanTom; April 19th, 2011 at 08:47 AM.. Reason: Forgot the code
Old April 20th, 2011, 02:43 AM
Imar's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

Hi Tom,

It looks like the database configured in the LocalSqlServer connection string (or with a different name if you changed settings in web.config) has not been prepared for the ASP.NET application services.

Where is the database you're using and how does it get there? If the database is in App_Data and contains no relevant data for you, you can delete it so it gets recreated the next time you use one of the Membeship services.

Hope this helps,

Imar Spaanjaars
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
The Following User Says Thank You to Imar For This Useful Post:
flashmanTom (April 21st, 2011)
Old April 21st, 2011, 08:28 AM
Authorized User
Join Date: Dec 2007
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default That was it!

Hi Imar,

Thanks for the response. You hit the nail on the head. The local server was not defined in the web.config.

See ya,

Thomas G Magaro
Old December 26th, 2012, 08:22 AM
Registered User
Join Date: Dec 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Ohk Shaguf. If you can, please let me know who can attend this conference and when is it going to take place next. I would love to attend this conference.

Similar Threads
Thread Thread Starter Forum Replies Last Post
HTTP error 500: Internal Server Error in Load Testing sherin Visual Studio 2008 0 May 19th, 2010 09:02 AM
Error on Map load tedr BOOK: Professional ASP.NET MVC 1.0 ISBN: 978-0-470-38461-9 1 February 17th, 2010 12:58 AM
error at reportDocument.Load akhilvira Crystal Reports 0 April 10th, 2007 12:00 AM
Error during load neetagp_21 Beginning VB 6 0 February 21st, 2007 02:16 AM
Load Report Error smysyk Crystal Reports 0 November 21st, 2005 01:26 PM

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