RE: ADO and bind variables (was RE: Performance improvement required :-))

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Pardee, Roy E
> Sent: Friday, June 13, 2003 20:10
> To: Multiple recipients of list ORACLE-L
> Subject: ADO and bind variables (was RE: Performance improvement
> required :-))
>
>
> This is interesting--if I use ADO with the ODBC provider (as
> the code does
> below), I get the same results. But if I use just ADO (that
> is, ms' OLE DB
> provider for oracle (MSDAORA.1)) then I don't get bind vars.
>
> (I'm doing INSERTs in my code, not SELECTs).
>
> I wonder if oracle's native OLE DB provider works any
> differently--I would
> bet that it does...
>
> Cheers,
>
> -Roy

Roy,

I tried with the Oracle provider (OraOLEDB.Oracle.1), and the bind variables work. Another reason to stick with the Oracle provider :-)

Ciao
Fuzzy
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).