Hi Fernand, trying to catch up with some of the unanswered questions here ...
> For speed reasons we use ADO to connect to a external MS SQLserver > based database. > > Making and using queries works fine but we can not use Named Parameters > in the queries Changing to ODBC permit us to uses Named Parameters but > then we loses a lot of speed. > > Is this normal behavior or > - do is have to change sometihng more when setting up the ADO connection > - do I go back to the old solution and use the macro to making ADO > working with Named Parameters In general, if the database does not support named parameters, but anonymous ones only, then Base allows to replace named with unnamed parameters before sending them to the DB. However, it seems this is not implemented for our ADO driver (but for ODBC/JDBC only), which could be considered a missing feature. If you care to submit a request for enhancement for this in IZ, then there are chances it can be fixed in 3.0. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
