Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Linking SQL Server tables to Oracle Tables DSN-Less

Re: Linking SQL Server tables to Oracle Tables DSN-Less

From: sgoneil <sgoneil_at_gmail.com>
Date: 1 Jun 2005 18:07:24 -0700
Message-ID: <1117674444.071744.211990@o13g2000cwo.googlegroups.com> 





Hey Gaz,



You can use Oracle Heterogeneous Services to allow ODBC based Database
Links to be created in the Oracle Server, after which you can query the
SQL Server tables via oracle and perform all standard ANSI sql
statements.



Cheers,



Shaun.
Received on Wed Jun 01 2005 - 20:07:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US