The stored procedure ' dbo.aspnet_checkschemaversion ' cannot be found in ASP.
After completing the profile's webconfig configuration, the runtime "cannot find the stored procedure ' dbo.aspnet_checkschemaversion '" error.
My Web. config configuration is as follows:
<connectionStrings> <add name="Con1" connectionString="Data source=haso33cn/sqlexpress ; Initial Catalog=db_netshop; Persist Security info=true; User Id=sa; pwd=1; " providerName="System.Data.SqlClient"/> </connectionStrings> <system.web> <compilation Debug="true" /> <authentication Mode="Windows" /> < profile automaticsaveenabled="true"defaultprovider=" SQLProvider "> <providers> <clear/> <add name= "sqlprovider" type=" System.Web.Profile.SqlProfileProvider " connectionstringname=" Con1 " ApplicationName ="/"/> </providers> <properties> <add name="NNNN"serializeAs="Xml" Provider ="SQLProvider" > </Add> </Properties> </profile > </system.web>
Program Debug Code:
protectedvoidPage_Load(object sender, EventArgs e) { "gxs"; }
The following error occurred:
The stored procedure ' dbo.aspnet_checkschemaversion ' could not be found.
Workaround:
Start aspnet_ in the c:/windows/microsoft.net/framework/v2.0.50727 directory Regsql.exe, and then configure it according to the connection string in the configuration file (connectionstrings in Web. config), and note the database that you want to use.
Test:
Open SqlServer2005, found in the database more than dozens of tables, including Aspnet_profile. Dozens of more stored procedures were found, including aspnet_checkschemaversion stored procedures.
Open the Aspnet_profile table: "profile.nnnn =" GXs "" record is saved in the table.
The stored procedure is not found in ASP. Dbo.aspnet_checkschemaversion