Hi!!!

We would like to print report which will fetch data from two different DB servers e.g. I am having a DB server oracle 10g and one DB Server SQL server 2005. How shall we proceed.?

Hello,

You may not be able to do that from Baan , but possible from following options.

1.Use VB or .net or any third party tools to do the same.

2.use link server function from sql 2005 and fetch the data by sql qry from both servers .

3.use Msaccess bridge both the database (oracle and Sql 2005) in it then build a simple Report in Msaccess.

Regards,
Sushil Kumar Mudaliar

Hi Sushil!!

I have already done it with .NET and also through Views.

But my problem is Client has two DB servers, one is of Oracle10g and other is of sqlserver 2005. I was trying it from Database Definitions and tables by database. Did you ever try from that?

Thanks for your response..