devxlogo

Use the Connection String and SQL Profiler to Identify Your Application

Use the Connection String and SQL Profiler to Identify Your Application

Most of the time, OLEDB drivers to the underlying database support the ApplicationName property, which can be configured under the Advanced Tab. This property can be very useful when there are multiple applications running on a server and you need to track which application is issuing bad SQL.

Here’s an example. In SQL Server, you’ve configured the Connection String using OLEDB Driver and set the ApplicationName to, say, “CTL.” If you go to SQL Profiler and run a trace, you’ll see all queries running which use the Connection String defined above, that appear with the Application Name of “CTL.” You can henceforth filter the application specific queries and better troubleshoot the problem.

See also  Does It Make Sense to Splurge on a Laptop?
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist