How to see the SQL's triggered from an ASP page

[Antony]

Hello,

I have an ASP page which runs SQL's on an Oracle db as per user selection. I am trying to use fiddler to capture these SQL's, but it doesnt seem to give me this information. 

I know this is possible as I have seen this working few years back. We added Query decompiler dll which would give me the SQL queries. The same dll doesnt seem to work any more. I tried it with different fiddler versions. I am not a web developer , so my knowledge is limited in that area.

This is quite urgent and any lead will be greatly appreciated. Thanks in advance :)

(and sorry if this is a very silly doubt)

-Antony.

[EricLaw]

In general, SQL queries between a webpage and a database server are executed over a raw TCP/IP connection that doesn't use HTTP and thus Fiddler can't see them.

If your server were somehow configured to execute these queries over HTTP, you'd need to configure it to use Fiddler as a proxy. See http://www.fiddlerbook.com/fiddler/help/hookup.asp#Q-IIS for details.