Re: Connecting to foreign Database via ODBC

From: TurkBear <johng_at_mm.com>
Date: Mon, 11 Oct 1999 15:51:43 GMT
Message-ID: <38020736.2988176@super.news-ituk.to>

For SqlPLus you can use

select * from table_at_ODBC:Odbcname

You cannot use this as a database link...Oracle thinks, in that case, that the portion after the @ refers to a tnsnames.ora entry...

private_comm_at_my-deja.com wrote:

>Hi,
>
>How do I connect to a foreign database via ODBC from PL/SQL or
>SQL*Plus? Would it also be possible to create a database link to it?
>
>Many thanks.
>
>PC
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Oct 11 1999 - 10:51:43 CDT