Last post Jan 27, 2011 10:57 AM by anand.csharp
Jan 27, 2011 10:42 AM|go4voip|LINK
Is it possible to use two database connection for one RPT?
i have customer info in MS SQL table and their transactions detailed in Oracle, i have also two Store procedured provided by my DBA.
I need to call one SP to connect with MS SQL with input paramter, and same other one with Oracle.
Please suggest me if i can call two SP with different database?
Jan 27, 2011 10:57 AM|anand.csharp|LINK
yes you can use two database, when ever you are using distributed architechure then you need service one connect database and another with other database , put that both table data in a single data set and create report from that dataset.
iif you are not interested to do same the create two connection string and call database and do the same work.