Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > BOOK: ASP.NET Website Programming Problem-Design-Solution
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution 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
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 28th, 2008, 05:59 PM
Registered User
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Hi all,

I have a .net 2.0 website that is running on a shared hosting environment. In this database I don't have administrative permission and can't run the tool C:\WINDOWS\Microsoft.NET\Framework\<versionNumber> \aspnet_regsql.exe due to database remote connection restrictions. I am getting the following error, which I have been searching is due to (within a shared environment) not having the database owner name included (instead of 'dbo') within all calls from the provider classes. For what I can see, the 'dbo' prefix is hard coded in build-in SqlMembershipProvider/SqlRoleProvider.

Someone with the same problem can give me some advice?? Otherwise, I'm afraid I have to write a custom membership/role provider.

Thanks in advance,

Dominik.

-----------------------------------------------------------------------------------------

Server Error in '/' Application.
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
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: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +1948826
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +4844747
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
System.Web.Util.SecUtility.CheckSchemaVersion(Prov iderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +378
System.Web.UI.WebControls.WebParts.SqlPersonalizat ionProvider.CheckSchemaVersion(SqlConnection connection) +69
System.Web.UI.WebControls.WebParts.SqlPersonalizat ionProvider.LoadPersonalizationBlobs(WebPartManage r webPartManager, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) +204
System.Web.UI.WebControls.WebParts.Personalization Provider.LoadPersonalizationState(WebPartManager webPartManager, Boolean ignoreCurrentUser) +94
System.Web.UI.WebControls.WebParts.WebPartPersonal ization.Load() +103
System.Web.UI.WebControls.WebParts.WebPartPersonal ization.LoadInternal() +23
System.Web.UI.WebControls.WebParts.WebPartManager. OnInit(EventArgs e) +293
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378


Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
  #2 (permalink)  
Old December 29th, 2008, 03:35 PM
Authorized User
 
Join Date: Dec 2008
Location: London
Posts: 50
Thanks: 1
Thanked 5 Times in 5 Posts
Default

Hi Dominik

I cann't be much help at this very moment because i am still completeing my project which i need to host in a shared server. The hosting also does not provides remote connections.

I am using godaddy's hosting, well they have all the asp membership tables and stored procedure already in my database. I am not sure if i will be able to use.

I was thinking of using LINQ and creating classes for all the tables and then using LINQ's create tables function, i am not sure if it will import the stored procedures.

i think you can export your whole database as script and import it on the web server.

i am not sure if it will work but worth trying.

i will try to post the solution if i get mine working....

thanks
  #3 (permalink)  
Old January 8th, 2009, 05:17 PM
Registered User
 
Join Date: Dec 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi again,

Finally, my hosting at aruba.it does not want to run the scripts needed to give the necesary access to my database user, so I still have the same error because my database owner in not 'dbo' which is who all ASP.NET providers call hard coded as prefix. I don't have administrative permission, so I must deal between my hosting restrictions and the Microsoft hard coded implementation solutions.

Has anyone some other solution?

Otherwise, I must overwrite all the providers or try it in a better hosting...

Thanks.
 


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
valid dbo; permission to impersonate dbo est BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 5 February 21st, 2007 04:44 AM
Can't find a Procedure? ChengWei BOOK: ASP.NET Website Programming Problem-Design-Solution 8 October 31st, 2006 10:31 PM
Could Not find stored Procedure kavyach BOOK: ASP.NET Website Programming Problem-Design-Solution 1 June 10th, 2005 06:53 AM
Could not find stored procedure ianmc BOOK: ASP.NET Website Programming Problem-Design-Solution 16 August 20th, 2004 03:40 PM
Could not find stored procedure 'sp_Polls_GetCurre jblp BOOK: ASP.NET Website Programming Problem-Design-Solution 1 September 18th, 2003 06:10 AM



All times are GMT -4. The time now is 01:31 PM.


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