Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VB6 Oracle Connection without installing Oracle Client..
You can make a datasource without installing the client you just can't
connect - which seems like a futile exercise.
You need the Oracle client.
ODBC, ADO etc. is just an API to the underlying native API of a database.
In this case the underlying native API of the database is OCI (Oracle call
interface). To make calls to that interface you need the Oracle client.
The Oracle client knows how to talk by its own API over the wire to the
Oracle server. (I forget what Oracle internally calls this - UPI I think -
but they don't publish it)
In case there was any confusion:
You need the Oracle client.
Jim
"Blaine Jones" <seismo123_at_alltel.net> wrote in message
news:a5au7a$88d$1_at_iac5.navix.net...
> On that train of thought, what IS required to make an ADO connection to an
> Oracle database via VB6?
> Must the Oracle client be installed or can an ODBC datasource be defined
> without installing the client?
>
> Thanks.
>
> Blaine
> --
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:a20d28ee.0202220612.54877784_at_posting.google.com...
> > david_at_ionideainteractive.com (David Jeyathilak) wrote in message
> news:<3e9566e2.0202220354.2c24d688_at_posting.google.com>...
> > > I am using VB6 at my client end(Pentium, Win 98) and using oracle 8i
> > > as my server(Solaris). I want to connect to Oracle through any means
> > > without having installed Oracle client and not created Data Source at
> > > my client end. Is it possible? Please help.
> > >
> > > regards,
> > > David
> >
> > NO
> >
> > Regards
> >
> > Sybrand Bakker
> > Senior Oracle DBA
>
>
Received on Sun Feb 24 2002 - 11:16:02 CST