Integration of Oracle 10g with MSSQL

Hi there all the database master,
i have a doubt here that would like to have some advice from u all. Can i get data from Oracle 10g database if i have an application running on MS SQL ? If can, would it be cumbersome afterall? Please advice.... an application running on MS SQL Server ... ?

Anyway, I get the picture. Yes you can create a connection to the Oracle database and then for instance create a linked server using that (ODBC for example) connection. You can query the data within the Oracle instance from within the ... application running on the MS SQL ... ;)

HTH

Gr,
Yveau