Page 1 of 1

Using DBMonitor with ASP.NET projects

Posted: Thu 30 Jul 2009 10:32
by hannes_a
I'm unable to use DBMonitor on 5.25.37
- First: I can't drag OracleMonitor to ASP site, why ?
- Second: I found this in your help
To trace your ASP.NET applications you must perform some additional steps. As ASP.NET application by default is started under ASP.NET Windows account it can not share information that DBMonitor uses with the account where DBMonitor is running. Therefore you need to follow the next steps:

Start ASP.NET with the same Windows account where DBMonitor runs.
Open machine.config file from WindowsDir\Microsoft.NET\Framework\vX.X\config\machine.config.
Find tag.
Change userName attribute value to your Windows account name and password to your account password.
Setup ASP.NET service in order that it has access to current user Desktop services. To do it open Service Control Manager and find IIS Admin service. Open its properties dialog. Go to Log On tab and check 'Allow service to interact with desktop' checkbox.
Restart IIS.
I find no userName attribute value, which I can change.
Please provide an example !

Posted: Fri 31 Jul 2009 11:48
by Shalex
Please try adding the following entry to the web.config file of your ASP.NET application instead of editing machine.config:

Code: Select all

<system.web>
		<identity impersonate="true" userName="***" password="***" />
</system.web>
The userName attribute value is your Windows account name, and password is your account password.
Then create in code an instance of the Devart.Data.Oracle.OracleMonitor class and set its IsActive property to true.

Posted: Wed 12 Aug 2009 19:16
by hannes_a
thank you, I did this

Code: Select all

 protected void Page_Load(object sender, EventArgs e)
        {  
            OracleMonitor myMonitor = new OracleMonitor();
            myMonitor.IsActive = true;
        }
but I didn't see all queries (only lookup queries) and I miss the execution of the update statement
What did I wrong ?

Posted: Thu 13 Aug 2009 10:17
by Shalex
Have you inspected all connection objects which are displayed in DBMonitor? Probably, the update statement was executed with another OracleConnection object. Please navigate through all OracleConnection objects which are displayed in the DBMonitor window to find the one with the update statement.

Posted: Thu 13 Aug 2009 11:00
by hannes_a
of course, I looked to all dbmonitor OracleConnection entries but I miss some

Posted: Fri 14 Aug 2009 14:09
by Shalex
Please confirm that the execution of the update statement is displayed in DBMonitor. If not, please send us (support*devart*com) a small test project and the DDL/DML script to reproduce the problem, because we cannot reproduce it at the moment.

Posted: Tue 18 Aug 2009 20:05
by hannes_a
I found my mistake, instead of

Code: Select all

public partial class FormQuot : BasePage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            OracleMonitor myMonitor = new OracleMonitor();        
            myMonitor.IsActive = true;
I use this, and it did the job

Code: Select all

public partial class FormQuot : BasePage
    {
        OracleMonitor myMonitor = new OracleMonitor();        
        protected void Page_Load(object sender, EventArgs e)
        {
            myMonitor.IsActive = true;