Re: Microsoft ADO-> Oracle Net8

From: <lempert_at_my-deja.com>
Date: 1999/10/04
Message-ID: <7t9k8t$ghb$1_at_nnrp1.deja.com>#1/1


In article <7rjkb5$n1e$1_at_foo.grnet.gr>,   "Vasileios Lourdas" <lourdas_at_it.teithe.gr> wrote:
> Hi.
> Ummm... That message indicates that you probably need to install SQL
 Net
> client, but i'm not so sure though.
>
> --
> ~~~~~~~~
> + Vasileios Lourdas
> + Informatics Department,
> + TEI of Thessaloniki(Greece), 8th semester
> + e-mail : lourdas_at_it.teithe.gr
> + http://aetos.it.teithe.gr/~lourdas
> ~~~~~~~~
> Mark van Osch <Mark.vanOsch_at_nl.origin-it.com> wrote in message
>

news:0E16861EE7BCD111BE9400805FE6841F0B5FD549_at_c1s5x001.cor.srvfarm.origi n-it
> .com...
> > I am unable to connect to my Oracle database (Oracle8 Server Release
> > 8.0.4.0.0) via aMicrosoft ADO connection. When I try to test my
 connection
 I
> > get the following error message:
> >
> > "Test connection failed because of an error in initializing
 provider. The
> > Oracle(tm) client and network components were not found. These
 components
> > are
> > supplied by Oracle Corporation and are part of the Oracle Version
 7.3.3.
 (or
> > greater) client software installation.
> >
> > You will be unable to use this provider until these components have
 been
> > installed."
> >
> > We are using Visual Basic 6.0 SP3.
> >
> > Could somebody tell me what I am doing wrong?
> >
> > Thanks,
> >
> > Mark van Osch
> >
> >
>
>

Hi
We're doing NT 4 server with VC++(6.0) with ADO in order to connect to NT and/or Unix Oracle 8x. While searching, there is a 7 page MSDN document on it titled 'Setting Up MTS to Access Oracle' which is found in 'Platform SDK:Transaction Server'. In short , U have to install an Oracle 7.3.4 client on the ADO NT which will connect to the Oracle server. Even if the Oracle and your app is on the same server, U need to install this 7.3.4 old version since ADO doesn't support Oracle8 client.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 00:00:00 CEST

Original text of this message