Multiple sp from multiple databases

Posts   
 
    
tvuong
User
Posts: 17
Joined: 27-May-2005
# Posted on: 02-Jun-2005 22:32:46   

Otis, I think I have a good ? for you.

Is there a way to LLBL can combine multiple sp's from multiple databases (could be from different servers) into one dataset/datatable?

thanks,

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 03-Jun-2005 09:24:09   

No, you can't, unless you add multiple catalogs to your project (i.e.: they're located on the same Sqlserver instance). So you first have to fetch the data in separate datatables, then merge these manually.

Frans Bouma | Lead developer LLBLGen Pro