SQLExecDirect and SQLNativeSQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

dsearl_at_gtsoftware.com
Date: 06/18/04


Date: Fri, 18 Jun 2004 14:40:46 -0400

I have a VB application that send a SELECT statement to an ODBC driver using
ADO.

In the ODBC driver trace I see that my application is handing the driver 2
different formats of the SELECT statement and yet, my VB application program
only issues the SELECT over and over again (every 1/2 second, I'm polling a
DB2 database).

Does anyone know why or how it is that when I issue the SELECT it comes to
the ODBC driver as an SQLExecDirect statement sometimes and at other times
it comes in as SQLNativeSql statement.

Is this some settings in my VB application or is an ADO decision caused by
something?

Best Regards,
David



Relevant Pages

  • SQLExecDirect and SQLNativeSql
    ... I have a VB application that send a SELECT statement to an ODBC driver using ... In the ODBC driver trace I see that my application is handing the driver 2 ... Best Regards, ...
    (microsoft.public.vb.database.ado)
  • SQLExecDirect and SQLnativeSql
    ... I have a VB application that send a SELECT statement to an ODBC driver using ... In the ODBC driver trace I see that my application is handing the driver 2 ... Best Regards, ...
    (microsoft.public.vb.database.ado)
  • SQLExecDirect and SQLNativeSql
    ... I have a VB application that send a SELECT statement to an ODBC driver using ... In the ODBC driver trace I see that my application is handing the driver 2 ... Best Regards, ...
    (microsoft.public.data.ado)
  • RE: why can i use 3 conditions in SQL statement only?
    ... Could there be a string length limitation in the ODBC driver for AS400 eg ... Could you please post the content of the variable containing the sql string ... Regards, ... "Tarek" wrote: ...
    (microsoft.public.excel.programming)
  • Re: Creating MSAccess database file from a source code.
    ... >> ODBC driver? ... > With best regards, Mike Shkolnik ...
    (borland.public.delphi.database.ado)