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.

OK. Thanks.



My connection string is as follows:

Data Source="my computer name"\SQLEXPRESS;Initial Catalog=TPCShip;Integrated Security=True;Persist Security Info=False;Asynchronous Processing=True



The only difference between the example and mine is that I have a "named" Data Source, and my Default Structure Settings is set to SQL Server rather than Database Deployment Toolkit. My Initial Catalog is set (which I presume is correct, since that is the database I want to hit).



Is there anything else I should be looking for?