Getting SQL error on sp but still runs

[David C]

I have an aspx page with an editible GridView. When I click the Update
button the stored procedure runs (I know because the underlying data was
changed) but throws an exception as follows:

Source: .Net SqlClient Data Provider
An unhandled exception occurred:

Message: Cannot find the object 'rfp_updPeopleAndLink', because it does not
exist or you do not have permission.

I looked at the permissions and [public] has execute permissions.

I am using the DataSource UpdateCommand as follows:

UpdateCommand="EXEC rfp_updPeopleAndLink @Phone, @CellPhone, @Email,
@PersonID, @LinkNotes, @PrimaryPerson, @PropLinkID">

Any ideas on where I might look to resolve this? Thanks.

David

[David Wier]

Are you logging into the database with a connectionstring, that has a
particular user assigned to it?
does that user have permissions on the stored proc?

David Wier
http://aspnet101.com
http://iWritePro.com
"David C" <dl*****@lifetimeinc.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>I have an aspx page with an editible GridView. When I click the Update
button the stored procedure runs (I know because the underlying data was
changed) but throws an exception as follows:

Source: .Net SqlClient Data Provider
An unhandled exception occurred:

Message: Cannot find the object 'rfp_updPeopleAndLink', because it does
not exist or you do not have permission.

I looked at the permissions and [public] has execute permissions.

I am using the DataSource UpdateCommand as follows:

UpdateCommand="EXEC rfp_updPeopleAndLink @Phone, @CellPhone, @Email,
@PersonID, @LinkNotes, @PrimaryPerson, @PropLinkID">

Any ideas on where I might look to resolve this? Thanks.

David

[David C]

No, but I just found the problem. The stored proc code had a GRANT command
at the end besides the permissions also GRANTing execute to [public]. I
took out the code from the sp and now it works fine...no error. Boy, is
that strange!

David
"David Wier" <da*******@davidwier.nospam.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

Are you logging into the database with a connectionstring, that has a
particular user assigned to it?
does that user have permissions on the stored proc?

David Wier
http://aspnet101.com
http://iWritePro.com
"David C" <dl*****@lifetimeinc.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>>I have an aspx page with an editible GridView. When I click the Update
button the stored procedure runs (I know because the underlying data was
changed) but throws an exception as follows:

Source: .Net SqlClient Data Provider
An unhandled exception occurred:

Message: Cannot find the object 'rfp_updPeopleAndLink', because it does
not exist or you do not have permission.

I looked at the permissions and [public] has execute permissions.

I am using the DataSource UpdateCommand as follows:

UpdateCommand="EXEC rfp_updPeopleAndLink @Phone, @CellPhone, @Email,
@PersonID, @LinkNotes, @PrimaryPerson, @PropLinkID">

Any ideas on where I might look to resolve this? Thanks.

David