Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A problem with Oracle
anpallotta_at_flashnet.it wrote:
>Hi! I'm a young italian database administrator working in Oracle 7.
>I wish to query a SQLServer database through a database link, but the
>normal syntax don't work!
>The environment is an Oracle instance AND a SQLServer instance running
>on the same machine.
>How can i do to make this query efficient?
>Thanks a lot!!
A database link solves only part of the problem. You'll need to get Oracle's Transparent Gateway to MS SQL Server to access the SQL Server database from your Oracle7 database. Received on Sat Dec 28 1996 - 00:00:00 CST