Re: Does Sql Monitor work with ADO?

From: Kevin Frevert (Work_at_drinkingcoffee.com)
Date: 12/11/03 

Date: Thu, 11 Dec 2003 08:11:50 -0600

"Mark L. Tiede" <mtiede@mjwcorp.com> wrote in message
news:3fd87295$1@newsgroups.borland.com...
>
> I have an ADO connection that is connected to the same ODBC entry that
> Sql Explorer is using and logging. And yet, when it is used in my app,
> nothing gets logged to Sql monitor.
>
> case 1:
> Sql Explorer app -> BDE -> Native driver doesn't get logged
> case 2:
> Sql Explorer app -> BDE -> ODBC gets logged
> case 3:
> My Delphi app -> ADO -> ODBC doesn't get logged.

Case 1 and 2 works fine for me (BDE->Native MSSQL driver and ODBC). DBDemos
didn't work, but it is a desktop db. I could only guess the SQL is handled
internally and the table-based commands passed directly to the driver
(nothing for the SQL Monitor to monitor) or Borland hid those details on
purpose.

>
> But, in the end, it doesn't seem to log the Sql activity from an ADO to
> ODBC connection which is the functionality I need.

Yep, see my response to your first message.

krf

Relevant Pages

  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.sqlserver.connect)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.access.security)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)