tabs ↹ over ␣ ␣ ␣ spaces

by Jiří {x2} Činčura

Name and path of .NET program accessing Firebird database

5 Dec 2008 1 mins .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 .NET, C# and Firebird expert. He focuses on data and business layers, language constructs, parallelism, databases and performance. For almost two decades he contributes to open-source, i.e. FirebirdClient. He works as a senior software engineer for Microsoft. Frequent speaker and blogger at www.tabsoverspaces.com.