Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle ADO connection

Re: Oracle ADO connection

From: Beaux <bo_young_at_stuller.com>
Date: 4 Dec 2002 11:58:59 -0800
Message-ID: <e95636da.0212041158.6c353b6d@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 &#8216;Provider cannot be
> > found. It may not be properly installed&#8217;. 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US