> -----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).