StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » BO To Connect To Tables in Different Databases

BO To Connect To Tables in Different Databases

Jeff Pagley — Thu, 04 Oct 2007 14:54:56 GMT

Hi StrataFrame Team,

I have multiple databases running on a single SQL Server 2005 machine. I need to have a master database with master tables that all other databases/applications use. How do I setup my BO connections so that within the project/application which is using tables from one database I can access the master tables residing in the master database?

Thanks,

jjp

RE: BO To Connect To Tables in Different Databases

Trent L. Taylor — Thu, 04 Oct 2007 14:54:56 GMT

No problem :)

RE: BO To Connect To Tables in Different Databases

Jeff Pagley — Thu, 04 Oct 2007 14:21:42 GMT

Thanks for the info Trent!

RE: BO To Connect To Tables in Different Databases

Trent L. Taylor — Thu, 04 Oct 2007 10:23:43 GMT

You will want to create multiple data sources and then tie your BOs DataSOurceKey property to the correct connection. This can be done programmatically at run-time as well. First setup your data sources:

[codesnippet]DataBasics.DataSources(New SqlDataSourceItem("","My SqlConnection;Database=ApplicationSpecific;"))
DataBasics.DataSources(New SqlDataSourceItem("MASTER","My SqlConnection;Database=Master;"))[/codesnippet]

Next, on the BO you will want to assign the the DataSourceKey to any BO that needs to talk with the MASTER instead of the default ("" - Empty String By Default) connection. You can set this on the property sheet of the BO or set it in code:

[codesnippet]MyBO.DataSourceKey = "MASTER"[/codesnippet]