Re: Using ODP.NET connection for executing ADODB Command object

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sandeep Limaye (sandeep_limaye_at_persistent.co.in)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 21:55:16 +0530

Thanks David...yes, I agree that at some point in time we must get rid of
the old ADO and move on. But we need to provide some means of catering for
existing COM clients (that are not willing to move on, or will take some
time to move on) that pass the old ADO command objects to the
database-accessing component that has adhered to the newer data providers
(like ODP.NET).

Thanks again,
Sandeep

"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:uE107NkSEHA.1508@TK2MSFTNGP11.phx.gbl...
>
> "Sandeep Limaye" <sandeep_limaye@persistent.co.in> wrote in message
> news:uDaIB5jSEHA.1448@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I'm connecting to Oracle 9i database using ODP.NET (Using the
> > OracleConnection class). Can I use the same currently open connection
for
> > executing a stored procedure / query through an ADODB.Command object?
> >
>
> No. That cannot be done.
>
> > I may be expecting a bit too much, but is there any way that I can
achieve
> > this? I do not want to open a separate connection through
> ADODB.Connection,
> > and I also do not want to convert the ADODB.Command object to an
> > OracleCommand because the two differ greatly in their "CommandText"
> formats,
> > and it's a great pain if the CommandText is complex and has parameter
> > holders.
> >
>
> You really should byte the bullet and get rid of old ADO.
> ODP.NET binds parameters by position, or by name, whichever you prefer,
and
> it uses exactly the same "CommandText" format as PL/SQL and SQLPlus. So
as
> an added bonus, you can cut and paste from Visual Studio into Toad or
> SQLPlus or whatever.
>
> David
>
>

Relevant Pages

  • MS Access replacement?
    ... I'm looking to replace MS Access for an application I'm selling due to ADO ... problems I'm having with some users and wanting to get rid of the having to ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Remove apostrophe from text (export to Excel)
    ... Why exactly do you need to get rid of it? ... For Excel it defines the cell as ... when using ADO to read that data it should not ...
    (microsoft.public.data.ado)
  • Re: Ado Error
    ... COM based ADO is still used in many of my COM based DLLs. ... Over time, I will replace, but its not something I can snap my fingers and be rid of today:) ... Did you add reference to the ADO from your application? ...
    (microsoft.public.vb.database.ado)