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.

I've got a really naive question, but being a newbie to SF, I hope I'm forgiven. What's worse, I know exactly what you are talking about in the Connection string.



My issue is how do I see the connection string in the Business Object Mapper? I can see that the structure has a selected Class, Database, Table and Schema. But I see nowhere that I can view the connection string, other than the Connection String Override.



Help?

Hi Doug,

Nothing to worry about being newbie

To see the connection string do the following:

1. Open the BOM
2. Select your BO Library Project
3. Click the "Modify Project Properties" link on the right pane
4. You will have the Project Properties form which has the SQL Server Connection String as below:

Edhy Rijo