RE: view of a link

Oracle(r) Database Heterogeneous Connectivity Administrator's Guide 10g Release 2 (10.2) B14232-01 http://docs.oracle.com/cd/B19306_01/server.102/b14232/intro.htm#sthref17

Oracle(r) Database Heterogeneous Connectivity User's Guide 11g Release 2 (11.2) E11050-01 http://docs.oracle.com/cd/E11882_01/server.112/e11050/tgvsgc.htm#g1007512

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark Sent: Wednesday, August 21, 2013 1:32 PM To: oracle-l_at_freelists.org
Subject: RE: view of a link

I believe the feature is now DG4ODBC.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_Parallon.com Sent: Wednesday, August 21, 2013 1:23 PM To: Brian.Zelli_at_RoswellPark.org; oracle-l_at_freelists.org Subject: RE: view of a link

Depends on version of the database but you can use hsodbc to create a database link to the SQL Server Database.

I did that in the 9.2 and 10.2 days years ago. I have no idea if that is still a viable option or not. HSODBC is heterogeneous services.

Try a google search for hsodbc oracle sqlserver...

HTH
Chris

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Wednesday, August 21, 2013 12:17 PM To: oracle-l (oracle-l_at_freelists.org) Subject: view of a link

If I have a sql server table, can I create an oracle view of that table? ciao,
Brian

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 21 2013 - 20:00:25 CEST