Re: Trace Access Database Activity

Hi again Avi,

Sorry about the confusion, I didn't notice the MS-Access requirement.

This may be of more use to you...

(I've cut a snippet out from: =
http://www.microsoft.com/Mind/1198/faq/FAQ1198.ASP)

<cut start>
ODBC Trace is another useful utility for databases that don't have =
tracing facilities like the ones you get with SQL Server. This feature =
comes with ODBC Data Source Administrator, which can be accessed from =
the Control Panel. You can turn on the tracing feature by choosing the =
ODBC Control Panel applet, selecting the Tracing tab and clicking the =
Start Tracing Now button (see Figure 6). The trace information is logged =
in the sql.log text file, although the output log can be set from this =
Tracing screen as well. If you discover errors originating in your ASP =
files, check for the sections titled SQL_ERROR and DIAG in the log file, =
where you will find an appropriate error description. And just so you =
don't gum up your system's performance, make sure you turn off tracing =
after you're finished debugging.
<cut end>

Cheers,

- Mat

-----Original Message-----
From: Avi Nahir [mailto:[email protected]]
Sent: Wednesday, June 26, 2002 12:33 PM
To: [email protected]
Subject: [DOTNET] Trace Access Database Activity


Hi all,

I'm using ADO.Net to access an MS-Access database.
How can I trace what's going on? What queries are sent to the database?

You can read messages from the DOTNET archive, unsubscribe from DOTNET, =
or
subscribe to other DevelopMentor lists at http://discuss.develop.com.

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.