Could not find stored procedure 'Login'.

FCazabon posted on Monday, March 19, 2007

Hi,

I'm brand new to CSLA and pretty new to .NET.  I'm having a little trouble getting the PTWin project to run.  When entering the user name and password at the log in screen and pressing [OK] I get the error: Could not find stored procedure 'Login'.

I think this has to do with the connection string I am using.
I am using SQL Server standard version so the default values wouldn't work for me.  I have set my connection strings like this:

  <connectionStrings>
    <add name="PTracker"
         connectionString="Data Source=DATABASE=PTracker;SERVER=SAMAAN6;UID=Frank;Trusted_Connection=Yes"
         providerName="System.Data.SqlClient" />
    <add name="Security"
         connectionString="Data Source=DATABASE=Security;SERVER=SAMAAN6;UID=Frank;Trusted_Connection=Yes"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

Can anyone spot if I've done anything wrong?

Thanks for any help.

RockfordLhotka replied on Monday, March 19, 2007

It sounds like the connection string is OK - the client is attaching to the database and not finding the stored procedure. Are you sure you ran all the scripts, including the creation of the stored procedures, against the security database?

FCazabon replied on Monday, March 19, 2007

Thanks for jumping in!

I think I have it solved.  I looked for the umpteenth time at the connection string and realised I didn't need the "Data Source=" bit.  Got rid of that and now I am up and running.

What I had done is to attach the databases to SQL Server so I didn't have to run any scripts for creating the databases.  I double checked when I got the message that the stored procedures were there.

Thanks.