I'm having a problem with a Gridview's update statement in VS2005/Postgress SQL server. On testing this on my local PC running VS2005, and hitting a Postgres SQL server on a differnt box. I'm trying to find a way to monitor the SQL that is sent to the server, as I'm doing something wrong. With MS SQL Server, I have SQL Profiler. But I don't think any such tool exist with Postgres.
Any suggestions in VS2005 on how to capture this? Any tool recommend to work with Postgres?
We are using corelab's .net drivers for Postgres. http://www.crlab.com/
On my DEV PC I'm trying to run their DBmonitor. I'm trying to find all the documentation for this. I've been working with this: ms-help://MS.VSCC.v80/Core
Since this is an asp.net page, there is no form to drop the control into per the instructions. I click on VS2005/view/compnent designer and I can drag the compoent onto the dark grey page which in turn places the code in the aspx.vb page. I see the option to Set PgSqlMonitor.IsActive. I activate the DBmonitor app, I then run the web page and get nothing in DBmonitor.
So I move onto the second half of the directions below: Using DBMonitor with ASP.NET projects
However, I don't have the processtag in my machine.config file.