Originally posted by prav_saras
Hi You can also use ADO connection in VB to transfer data from sql server to the Oracle.
Or
u can use the DTS of sqlserver

regards

praveen

Hmmm... you would need to fire the DTS job from SQL Server side, not Oracle. I can only imagine it being done on an synchronous basis, not asynchronous like a trigger on Oracle would do. Can you explain that?

Since Transparent Gateways option is licensed separately I'd consider generic connectivity of HS before, maybe it meets the requirements:

http://download-west.oracle.com/docs...gvsgc.htm#9912