Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle ADO connection
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 Wed Dec 04 2002 - 13:58:59 CST