Re: DBLink MS SQL Server, Access, Excel ODBC and Oracle together?
- From: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
- To: ltiu@xxxxxxxxxxxxx
- Date: Mon, 13 Oct 2008 12:59:06 +0100
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@xxxxxxxxxxxxx|
| | Sent by: |
| | oracle-l-bounce@fr|
| | eelists.org |
| | |
| | |
| | 13/10/2008 12:17 |
| | Please respond to |
| | ltiu |
| | |
|---------+----------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: oracle-l@xxxxxxxxxxxxx
|
| 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
--
//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�^
Other related posts:
