Subject Re: [ib-support] SQL monitor tool...
Author Helen Borrie
At 12:43 AM 3/05/2003 -0400, you wrote:
>Hello,
>
>I just installed FB and an ODBC driver, and I pretend to test a development
>environment with MS Access and this database server.
>Developing with Access through ODBC I'll need a tool to see what SQL is
>actually arriving to the server.

All communication with the server occurs via clients - so the monitoring
tools don't monitor what arrives at the server but what is being passed TO
the server via the Firebird API.

>Will anyone know of such a tool in the open source ?.

I don't know of any for ODBC - that doesn't imply that there are none, though.

Visit http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_admin_tools
for a large listing of db admin tools, some of which provide capability to
monitor the SQL leaving client applications. The trick will be to find one
that can hook into your Access-to-ODBC interface.

This site might be worth a visit:

http://www.jepstone.net/FreeODBC/

If you are using Delphi or C++B then you might be able to "roll your own"
using free or cheap shareware components: see http://www.torry.net/db_sql.htm

If you know PHP or Perl, there might be something in this project which you
can adapt:
http://dbman.linux.cz/readme.html

hth
heLen