Re: Using bind variables with VB and ADO but viewing SQL_AREA shows non-bound parameters

That is RIGHT.....
The "rule" is pretty simple - When it comes to Oracle development...if you want best integration, scalability,
, performance, best usage of Orace features, maintemance....just FORGET about M$ stuff....just forget it......
, use VB ONLY for what it is...a GUI build tool....don't let it or ODBC, ADO....talk to Oracle....it's a LOST case M$ and Oracle just don't like each other...

My OO4O app don't need no odbc driver....don't care if the machine has the lastest ADO.....just runs
and talks happily with Oracle.

Another advice: NO DDL/DML in VB....use package/stored objects.

Jim Kennedy wrote in message ...
>You could switch to OO4O. (Oracle's Ole Objects.) Has nice syntax, uses
>bind variables, is fast.
>Jim
>
>--
Received on Wed May 14 2003 - 12:36:38 CDT