tabs ↹ over ␣ ␣ ␣ spaces

by Jiří {x2} Činčura

Name and path of .NET program accessing Firebird database

5 Dec 2008 .NET, Firebird

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.

Profile Picture Jiří Činčura is an independent developer focusing on data and business layers, language constructs, parallelism and databases. Specifically Entity Framework, asynchronous and parallel programming, cloud and Azure. He's Microsoft Most Valuable Professional and you can read his articles, guides, tips and tricks at www.tabsoverspaces.com.