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.

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.

Have you set up the DataSourceKey property of your BOs?

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.