Subject | Re: [ib-support] SQL monitor tool... |
---|---|
Author | Helen Borrie |
Post date | 2003-05-03T05:44:31Z |
At 12:43 AM 3/05/2003 -0400, you wrote:
tools don't monitor what arrives at the server but what is being passed TO
the server via the Firebird API.
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
>Hello,All communication with the server occurs via clients - so the monitoring
>
>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.
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