Home -> Mailing Lists -> Oracle-L -> Re: DBLink MS SQL Server, Access, Excel ODBC and Oracle together?

Re: DBLink MS SQL Server, Access, Excel ODBC and Oracle together?

From: Ian Cary <ian.cary_at_ons.gsi.gov.uk>
Date: Mon, 13 Oct 2008 12:59:06 +0100
Message-ID: <OF3A671104.0749D214-ON802574E1.00412721-802574E1.0041D615@ons.gsi.gov.uk> 





Take a look at Oracle Hetergeneous Services.



There are a few ways to implement this but the most straightforward seems
to be to create an ODBC datasource for your MS object and then create a
local Oracle Hetergeneous service and listener. Once you have done this you
can create tnsnames entries and db links to the listener in the normal
fashion.



Cheers,



Ian




|---------+----------------------------->


|         |           ltiu_at_alumni.sfu.ca|

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           13/10/2008 12:17  |

|         |           Please respond to |

|         |           ltiu              |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       oracle-l_at_freelists.org                                                                       |
  |       cc:                                                                                                    |
  |       Subject:  DBLink MS SQL Server, Access, Excel ODBC and Oracle together?                                |
  >--------------------------------------------------------------------------------------------------------------|








Hi guys,



Is there a way for me to somehow create a "dblink" between different
databases (MS SQL Server, Acess, Excel ODBC and Oracle) and access these
through a single sql interface and join the tables from different databases
into views?



Thanks.


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



This email was received from the INTERNET and scanned by the Government
Secure Intranet anti-virus service supplied by Cable&Wireless in
partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In
case of problems, please call your organisation’s IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.


For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk

*********************************************************************************


Please Note:  Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
*********************************************************************************


Legal Disclaimer  :  Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
*********************************************************************************


The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^


Received on Mon Oct 13 2008 - 06:59:06 CDT












Original text of this message