StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Multiple Databases in Project

Multiple Databases in Project

Geoff Hirst — Sun, 18 Jan 2009 14:22:56 GMT

Hi,

I have a project that has 3 databases. All has deployed fine, when I try and populate a business objects from anything but the first database, all I get is Could not find stored procedure 'proc name'.

I have set up the connections in SetDataSources.

This one has me stumped, I have checked the actual SQL Server the proc I am trying to call is in place.

What am I missing ?

thanks guys

Geoff.

RE: Multiple Databases in Project

Geoff Hirst — Sun, 18 Jan 2009 14:22:56 GMT

Thanks Ivan/Trent,

Not done a multiple db system for a while and this customer has a Firebird (scary!!) db that I have replicated in SQL Server. I needed to get the stuff into my app from this db.

regards

Geoff.

RE: Multiple Databases in Project

Trent L. Taylor — Thu, 15 Jan 2009 15:39:32 GMT

I think Ivan may be going down the right road here. Have you setup all of your data sources to each of the databases?

RE: Multiple Databases in Project

Ivan George Borges — Wed, 14 Jan 2009 19:38:45 GMT

Hi Geoff.

Have you set up the DataSourceKey property of your BOs?

RE: Multiple Databases in Project

Geoff Hirst — Wed, 14 Jan 2009 17:05:15 GMT

Hi,

A bit more info.

If I prefix the dbname followed by .. to the procname, all is well. Yet, the BO has the correct Databae name in place.

So, this looks like it is only connecting to the 'first' database, and firing everything thru that. Is this how it is supposed to be?

thanks

Geoff.