Re: odbc and Oracle

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

"dave" <dreaburn_at_my-deja.com> wrote in message news:93epgu$dbj$1_at_nnrp1.deja.com...
> I want to connect to an Oracle instance via ODBC. On my PC it works
> fine as I've got Oracle client installed.
>
> On other PC's, I tried setting up an ODBC entry using the Microsoft
> ODBC for Oracle driver (ver 2.573.4202) but it states that you have to
> install the Oracle client software first.
>
> Is this the only way?

Yes, ODBC runs on top of sqlnet/net8

I don't know much about ODBC but I thought the
> point was that you don't have to install the vendors client library.

No, IMO, the point about ODBC is you can query multiple different databases from your client in a standard fashion. This means the driver will usually translate only and run on top of the existing sw
>
> If I have to install Oracle Net8, can I download this from Oracle's
> website?
>

Yes, though you would need to download either Personal Oracle 8i or the full Enterprise Edition.
AFAIK this is the only sw publicly available and you need a support contract for full access.
> Many thanks
> dave
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 09 2001 - 08:19:44 CST