Re: ODBC Tracing with Vista

Yes, I have all the normal bits and pieces ...

There is an ODBC driver for the software, its based upon an Access MDB

I turn on tracing in the control panel ODBC applet and the trace does work.

Its just that whereas the same software on my XP machine includes all the
select statements, the Vista machine does not.

Its down to the Vista machine not reporting the select statements for some
strange reason.

jON

"Bob Hairgrove" <NoSpamPlease@xxxxxxxx> wrote in message
news:t0o1j3p0fi6i6ha947ob4qpd5e68td4gb3@xxxxxxxxxx
On Tue, 6 Nov 2007 17:56:13 -0000, "Jon Rowlan" <jon.rowlan@xxxxxxxx>
wrote:

I have a situation now where ODBC trace on an XP machine with MDac 2.8
reports all the embedded select statements but where the exact same app
running on a Vista machine (no mdac installed as I can't find one relevant
to Vista) does not excho ANY of the select statements at all.

It sounds as if there is no ODBC driver manager on the Vista machine.
Since I don't use Vista, I can't really help ... but is there
something like "Control Panel" in Vista where you can create an ODBC
data source? How are you turning on ODBC trace? Is there an
ODBC32.DLL on the Vista machine?

Are you really using ODBC here? Depending on the application and the
database involved, it may be bypassing the ODBC driver entirely.
Microsoft, AFAIK, has threatened to phase out support for ODBC at
some point in favor of OLEDB...maybe this is it?

--
Bob Hairgrove
NoSpamPlease@xxxxxxxx


.

Relevant Pages

  • Re: ODBC Tracing with Vista
    ... reports all the embedded select statements but where the exact same app ... It sounds as if there is no ODBC driver manager on the Vista machine. ...
    (microsoft.public.data.odbc)
  • Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
    ... Managed ODBC provider to optimize the memory consumed for ... read from the native ODBC driver underneath the managed adapter. ... This call and setting is used when SSIS is reading data from a Managed ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
    ... SSIS packages utilizing some 3rd party ODBC ... Managed ODBC provider to optimize the memory consumed for ... read from the native ODBC driver underneath the managed adapter. ...
    (microsoft.public.sqlserver.dts)
  • Re: Reading mm datasource
    ... Word is trying to connect using the OLE DB provider ... (this is what Word generates when you try to connect manually using ODBC) ... both the OLE DB provider and ODBC driver that I have here (as ...
    (microsoft.public.word.mailmerge.fields)
  • ANN: DbxoODBC 3.015 - Kylix/Delphi Open Source dbExpress driver
    ... I am glad to announce the newest "dbxoodbc" release 3.0.1.5, ... ODBC. ... - Microsoft SQL Server odbc driver. ... you must test with the latest version from the CVS area: ...
    (borland.public.delphi.thirdpartytools.general)
Loading