See Sybrands answer for how to load the products you have downloaded.
Specifically the Universal installer looks for a file called products.jar
that tells it where everything is. The ODBC driver is not however the OLEDB
provider. That can be found at
http://technet.oracle.com/software/tech/windows/ole_db/content.html
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Beaux" <bo_young_at_stuller.com> wrote in message
news:e95636da.0212041158.6c353b6d_at_posting.google.com...
> Thanks for the info. I downloaded what they called the ODBC provider
> for 8.1.7 from technet.oracle.com and most of what I got was Jar files
> and no dll's or info on how or what to load. Did I get the wrong
> thing? How and what do I load? Any answer would be appreciated.
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<3dedcb3c$0$230$ed9e5944_at_reading.news.pipex.net>...
> > Run the universal installer and have a look at installed products to see
if
> > it lists the oledb provider. If it does you can always reinstall, or
even
> > better download the latest provider from technet.oracle.com
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "Beaux" <bo_young_at_stuller.com> wrote in message
> > news:e95636da.0212031114.79812879_at_posting.google.com...
> > > I posted this a month or so ago and never got a real answer. Thanks
> > > for any response.
> > > I am trying to connect to Oracle using ADO and the provider is giving
> > > me an error. I thought I had everything downloaded and installed. I
> > > connect with Toad fine. I get the error ‘Provider cannot be
> > > found. It may not be properly installed’. This is an example of
> > > how I am trying to connect. I get the error at .Open. The Me.Fg
> > > stuff is a Flex Grid. Where can I find the correct version of Oracle
> > > provider and install it?
> > >
> > > Dim Ora_Conn As ADODB.Connection
> > > Dim Ora_Rs As ADODB.Recordset
> > >
> > > Set Ora_Conn = New ADODB.Connection
> > > Set Ora_Rs = New ADODB.Recordset
> > >
> > > With Ora_Conn
> > > .ConnectionString =
> > > "Provider=OraOLEDB.Oracle.1;Password=apps;Persist Security
> > > Info=True;User ID=apps;Data Source=crp1"
> > > .Open
> > > End With
> > >
> > > Ora_Rs.Open "Select Name From qp_Price_Formulas Order by Name",
> > > Ora_Conn, adOpenStatic, adLockOptimistic
> > >
> > > Set Me.Fg.DataSource = Ora_Rs
> > >
> > > My Oracle version.
> > > RDBMS : 8.1.7.2.0
> > > Oracle Applications : 11.5.3
Received on Thu Dec 05 2002 - 03:20:00 CST
