Re: Basic ODBC question

From: K. Raghuraman <kraghu_at_india.hp.com>
Date: Fri, 20 Nov 1998 10:59:53 +0800
Message-ID: <3654DB29.D92AE901@india.hp.com>

You can use Gateways to achieve this.

Raghu

smart wrote:
>
> No Way!
>
> bdg_at_hotmail.com wrote:
>
> > I'm unfamiliar with ODBC and need a short crash couse . . .
> >
> > Can I create an Oracle view which transparently queries a SQLServer database
> > through ODBC?
> >
> > For example:
> >
> > CREATE VIEW MyView AS
> > SELECT Column1, Column2
> > FROM TableA_at_sqlserver;
> >
> > If so, what software components are involved and where do they reside?
> >
> > I'm 98% sure that this is true, but am having difficulty finding
> > documentation.
> >
> > I'm looking for any options besides Transparent Gateway which seems pricey
> > for the limited query-only functionality that I need.
> >
> > Thanks,
> > Brian Gastineau
> > gastineau_at_poboxes.com
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Nov 19 1998 - 20:59:53 CST