Re: Oracle & SQL Server

From: Jens K Jensen (jensk2_at_hotmail.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 19:04:37 +0100

Sure! Look up sp_addlinkedserver in BOL:

EXEC sp_addlinkedserver
   @server = 'LONDON Mktg',
   @srvproduct = 'Oracle',
   @provider = 'MSDAORA',
   @datasrc = 'MyServer'
GO

Then consider to create Views to make it easy to access the remote Oracle
tables. Oracle connectivity has even been tested:

Microsoft® SQL ServerT 2000 distributed queries have been tested with
several OLE DB providers. Some of the tested OLE DB providers are installed
with SQL Server 2000:
  a.. Microsoft OLE DB Provider for SQL Server

  b.. Microsoft OLE DB Provider for ODBC

  c.. Microsoft OLE DB Provider for Jet

  d.. Microsoft OLE DB Provider for DTS Packages

  e.. Microsoft OLE DB Provider for Oracle
regards
jensk

"Nils Magnus Englund" <nils.magnus.englund@orkfin.no> wrote in message
news:%23s4wGz1CEHA.2576@TK2MSFTNGP11.phx.gbl...
> Is it possible to create a view in SQL Server which incorporates tables
from
> an Oracle database? It can be a ODBC connection, I don't care much about
> speed etc. Just is it possible? :) Any tips/suggestions/links to more
> information etc. would be great!
>
> Thanks.
>
>
> Sincerely,
> Nils Magnus Englund
>
>

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: Admin Server 2003 myself? Or find someone to host?
    ... to do yourself -- configuration of SQL for your app and setup of your .Net ... where the server is hosted for an ASP.Net app as a good Internet provider ... These providers all geographically far away from my city ... and share an individual SQL Server instance ...
    (microsoft.public.windows.server.general)
  • 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 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)
  • Re: How to make your report run faster
    ... I've done no work with Oracle as the Server DB, ... > if they click the listbox then "Preview report" button is enabled. ... > -I was try to make the old queries for subreport, ...
    (microsoft.public.access.reports)
Loading