I just downloaded this code and it wouldn't run. I extracted the whole file structure including all 4 websites. The other 3 websites in the download work. The PCSDemoSite starts up in the browser with no errors, warnings or messages. However, it gives this error as soon as I try to log in as User1, using password User1:

"Procedure or function aspnet_Membership_GetPasswordWithFormat has too many arguments specified."

This is followed by a screen-filling Stack Trace dump.

Has anyone seen this problem? Is this is a bug in the original code? I'm not quite proficient enough yet.

Thanks!

Jim

Hi,

I've just purchased this book and it's excellent. BTW I also own prior version of this book.

Now come to the point. I've not yet read that chapter but can give you some hints to hunt the bug down.

• Open the web.config file of the website in error and locate the compilation tag. Make sure it reads like this:
  
  Code:

  <compilation language="C#" debug="true" />

• Open the SQL server database used in the sample and, drill down to Stored Procedures and double click the aspnet_Membership_GetPasswordWithFormat stored procedure. This opens the stored procedure in an editor.
• Now run your web site and place a breakpoint where your c# code is calling the stored procedure.
• The problem must be that the C# code is passing more parameters to the stored procedures that it has defined. For example, it may have a @UserID and @Password parameters but you code might be trying to pass it @UserType parameter along with the two other parameters. Since @UserType parameter is not defined the stored proc will throw error.
• Make sure you remove any extra parameters that're being supplied. [*/]

Hopefully, you should be able to solve the problem.

ejan

Had the same problem, and couldn't find anywhere Visual Studio would accept a breakpoint. After two hours of head-banging, the answer turned out to be M$ changed something when ASP 2.0 left beta, and Wrox haven't updated their sample code to be compatible.

To fix, do this from the command-line:

aspnet_regsql -A all -C "Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" -d "C:\ProCSharp\Chapter27\Websites\PCSDemoSite\App_D ata\aspnetdb.mdf"