sqlException was unhandle by user code!

[pandapatin]

Could not find stored procedure 'DBAuthenticate'. --> cmdSelect.ExecuteNonQuery()

[Dave Kreskowiak]

It's telling you that your database doesn't have a stored procedure called "DBAuthenticate". Either you got the SP name wrong in your code, or you're not connected to the database you think you are when this call was made. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[pandapatin]

i got the DBAuthenticate function but still the same error appears.how can i made the connection?or test the connection is there?

[Dave Kreskowiak]

If you get this error, your connection is being made successfully. There are still the problems that I mentioned, plus the possibility that your code is either using an SQL account or running under a Windows account that does not have the permissions to execute that stored procedure. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome