Re: Oracle & SQL Server
From: Nils Magnus Englund (nils.magnus.englund_at_orkfin.no)
Date: 03/18/04
- Next message: Thomas Kratz: "Index with strange statistics?"
- Previous message: Sajal Kumar: "Re: Resultset from 6.5 compared to 2000"
- In reply to: Jens K Jensen: "Re: Oracle & SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 18 Mar 2004 18:41:03 +0100
Great, thanks to both of you! :)
"Jens K Jensen" <jensk2@hotmail.com> wrote in message
news:OOs8mE4CEHA.2620@TK2MSFTNGP12.phx.gbl...
> 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!
> >
- Next message: Thomas Kratz: "Index with strange statistics?"
- Previous message: Sajal Kumar: "Re: Resultset from 6.5 compared to 2000"
- In reply to: Jens K Jensen: "Re: Oracle & SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
