StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Trying to Configure Connection to 2 Different DataBases

Trying to Configure Connection to 2 Different DataBases

Terry Bottorff — Mon, 26 Mar 2012 13:38:44 GMT

I have the following code in my AppMain and when I first run the application it runs through the connection manager and I attach it to the correct databases. One is on the Web and one is Local.

I have a form that just uses the Web DataBase and I have the BO's DataSourceKey all set to WebProRodeoData. It works as I want it too.

Now I am setting up a form where I want to connect to my local data and I have set the BO's DataSourceKey to LocalProRodeoData2

but I get the attached error when I try to configure the BO in the BOM.

Is there something else I should be doing?

[codesnippet]

		ConnectionManager.ApplicationKey = "ProRodeoUpdateWeb"

		ConnectionManager.ApplicationDefaultTitle = "ProRodeoUpdateWeb Connection"

		ConnectionManager.ApplicationDefaultDescription = "This application connection is used by ProRodeoUpdateWeb"

         '-- Set the required data source information so that the ConnectionManager can gather it

        '      SQL Connection

        ConnectionManager.AddRequiredDataSourceItem("WebProRodeoData", "SQL Connection", _

         DataSourceTypeOptions.SqlServer, "WebRodeoData", "This connection is used by Pro-Rodeo Web Data.")

         '-- Set the required data source information so that the ConnectionManager can gather it

        '      SQL Connection

        ConnectionManager.AddRequiredDataSourceItem("LocalProRodeoData2", "SQL Connection", _

DataSourceTypeOptions.SqlServer, "LocalRodeoData", "This connection is used by Pro-Rodeo Local Data.")

[/codesnippet]

TIA.

RE: Trying to Configure Connection to 2 Different DataBases

Edhy Rijo — Mon, 26 Mar 2012 13:38:44 GMT

You are welcome Terry, glad it worked out for you.

RE: Trying to Configure Connection to 2 Different DataBases

Terry Bottorff — Mon, 26 Mar 2012 13:17:00 GMT

Yes Sir Edhy a Direct Hit. Just like always exactly what it took to fix the problem. Thank you so much.

RE: Trying to Configure Connection to 2 Different DataBases

Edhy Rijo — Mon, 26 Mar 2012 12:18:14 GMT

Hi Terry,
The database connection in the BOM has nothing to do with the connection in your AppMain.vb file. The BOM only needs to get a connection to a database with the same data structure as the one you will be using in your application so it can read the table schema and create the BO fields for you. If you would use the DDT, then you should map your BOM to the DDT instead of the database except for views which will need to be read from any database.

So bottom line is this:

Make sure the BOM connection is to any local database that has the same structure as expected for your application.
The connections in your AppMain.vb looks just fine.