Trying to Configure Connection to 2 Different DataBases


Author
Message
Terry Bottorff
Terry Bottorff
Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)
Group: Forum Members
Posts: 448, Visits: 12K
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?

      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.")

TIA.


Attachments
BOMapperError.png (102 views, 38.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search