5
Dec
Tags: , | 5 Comments »

Name and path of .NET program accessing Firebird database

Firebird 2.1 has a feature called monitoring tables. You can look at what’s going on inside the database – like connections, running commands etc. For mon$attachments there’s column called mon$remote_process, where you can find path (from client POV, of course) to the program. But this needs cooperation from client. And from now, FirebirdClient (ADO.NET provider for Firebird) does this cooperation. So when you connect to Firebird with your .NET application, you (or maybe better admin) is able to look at above mentioned table(s) and see what commands is your application executing etc.

There's 5 Comments So Far

  • F8R
    December 25th, 2008 at 00:28

    I know your bussy for Entity Framework and .NET 3.5.Any update on Firebird .NET for 2.0 Provider?To catch up with newest Firebird 2.1 feature.

  • cincura.net
    December 25th, 2008 at 09:53

    What features?

  • Ali
    January 31st, 2009 at 09:47

    I couldnt find the table mon$attachments in the system tables.

  • cincura.net
    January 31st, 2009 at 10:51

    You have to run FB2.1 server and database with this ODS.

Who Linked To This Post?

  1. Firebird News » Name and path of .NET program accessing Firebird database

Share your thoughts, leave a comment!