Re: Linking Oracle DB to SQL DB

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 13:29:10 -0700

Hi Susan,
Try the following article for steps on how to set up a
linked server to Oracle:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106

-Sue

On Tue, 24 Feb 2004 11:29:34 -0800, "Susan"
<anonymous@discussions.microsoft.com> wrote:

>Hello
>
>Where can I find information on how to link an Oracle
>database to a SQL Server. Recently I wrote a small
>database in Access linking the tables I need from the an
>Oracle database using ODBC drivers but had alot of
>connectivity and locking problems. I was advised to link
>the Oracle server to SQL Server using Access as frontend.
>I am familiar with SQL Server, .net and Access but not
>familiar with Oracle. I played with the Linked Server in
>SQL an was able to link other SQL servers but not Oracle
>giving an MSDAORA error.
>
>I have read articles that you can't just link the Oracle
>server using OLEDB or other connectivity sources you must
>install a client from Oracle. I downloaded an OUIRelease
>after reading the release notes I don't really know what
>to do....
>
>Any information is greatly appreciated
>
>Frustrated
>Susan
>
>Susan

Relevant Pages

  • [NEWS] Multiple Vulnerabilities in Oracle Database (Character Conversion, Extproc, Password Disclosu
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the (Oracle database server ... password is required to exploit this vulnerability. ...
    (Securiteam)
  • RE: ODBC to Oracle 64bit missing rows
    ... the set of Oracle queries that I'm running ... through the linked server right now haven't given me that error.... ... I'm trucking on with 64-bit & Oracle's OLE DB drivers. ... I am on SQL Server 2005, ...
    (microsoft.public.sqlserver.connect)
  • Re: Linked Server
    ... SQL instance to be able to delegate on your behalf to the 2nd SQL Server ... [Create Linked Server Object on Middle Server] ... set up its login to use delegation. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Servers
    ... We have two servers, one MS SQL Server, the other Oracle. ... "x.x.x.x" was actually the IP address of the server. ... Funny, since MSDAORA is part of Windows, it should be there. ...
    (comp.databases.ms-sqlserver)
  • Oracle Connectivity Issue
    ... I've worked at sites with this configuration (SQL 2000 with an Oracle ... linked server) before with success. ... Now i am going to install sql server clustering, ... server,through linked server transfering data. ...
    (microsoft.public.sqlserver.clustering)