I am looking the mechanism to create the Database link from Oracle to SqlServer and Have to access the Objects in sqlserver from the Oracle.
And in the Same way i need to provide the Link from oracle to sqlserver and have to access the oracle objects from sqlserver.
I think you have to go for some EAI tools like IBM MQSeries or SeeBeyond to look fo rthese kind of solutions.
I think you can use 'Micrsosoft ODBC for Oracle' to link Oracle Objects to SQLServer.
I myself have had to set it up for an MSAccess developer.
That either sounds like an erogenous zone or a delicate surgical procedure.