Hi I have the following scenario for my application.

I have a single project (Web application) which interacts with 3 databases on different database servers.

For Example

3 Databases "DB1", "DB2" and "DB3".

"DB1" resides on the Database Server "Server A". (on network) "DB2" resides on the Database Server "Server B". (on network) "DB3" resides on the Database Server "Server C". (on network)

"DB1" contains a table "Table1" "DB2" contains a table "Table2" "DB3" contains a table "Table3"

I want to fetch data from "Table1", "Table2" and "Table3" by joining them on some criteria. Similarly I want to save/update data in these tables in the same transaction. How can i acheive this goal using Adapter service?

Thanks

lbluser

If you want to JOIN between these tables, then you would need to use one server or simulate that you are using one database server. This can be done by using a linked server for each of the external databases.

Then you can do the fetches and Joins as if you are dealing with one database server.

And when it comes to updates on different servers, you may use different DataAccessAdapters, one for each database, and use system transaction or a com+ transaction to execute Updates/Inserts on these databases.

Hi, Thanks for the reply. I have established Linker server but,

1. How will I get DB2,DB3 catalogs in the same Project(DB1 project). Since designer shows databases of the server instance "Server A" only not of the Linked servers. So the primary question is how to add different catalogs from different servers in the same project.

2. Or, I am on the wrong track.

Please, let me know how to get through this. I couldn't find more help regarding this.

Any level of detail is much appreciated.

Thanks.

You need to create synonyms or views in the main catalog for tables of the linked servers.

It still will be difficult, because there's just 1 connection, and meta-data retrieval from linked servers isn't supported (as it's impossible in most cases). Queries targeting linked servers also have to have longer names for tables, which isn't supported. Multi-catalog llblgen pro projects are for catalogs on the same server. Not about catalogs on different machines.

okez.