Unable to locate stored procedure


Author
Message
Doug Zapp
Doug Zapp
StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)StrataFrame Novice (101 reputation)
Group: Forum Members
Posts: 39, Visits: 225
Hi,



I'm in the process of determining which data update method I'd like to utilize, and have come across a little confusion. I've set up a table, and have a select, insert and update stored procedure (labelled like tablename_Insert as per recommendations). I have a business object which connects to said table. I've put the BO onto a form, and have a save function on the form. I set the BO property InsertUsingStoredProcedure to true. When I perform a save, the system reports an error with the message that it cannot locate the stored procedure named dbo.tablename_Insert.



However, if I qualify the BO on the form by setting the InsertStoredProcedureName to databasename.dbo.tablename_Insert, the save functionality works.



Any ideas?



Thanks,

Doug.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Doug Zapp - 16 Years Ago
Peter Jones - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Doug Zapp - 15 Years Ago
Edhy Rijo - 15 Years Ago
Doug Zapp - 15 Years Ago
Edhy Rijo - 15 Years Ago
Doug Zapp - 15 Years Ago
Doug Zapp - 15 Years Ago
Trent L. Taylor - 15 Years Ago
Doug Zapp - 15 Years Ago
Trent L. Taylor - 15 Years Ago
Doug Zapp - 15 Years Ago
Trent L. Taylor - 15 Years Ago
Doug Zapp - 15 Years Ago
Trent L. Taylor - 15 Years Ago
Doug Zapp - 15 Years Ago
Doug Zapp - 15 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search