ADO.NET not in SQL Profiler?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

When I use SQLDataAdapter to fill a dataset, the select
statement appears in SQL Profiler.

When I update the DataSet using SQLDataAdapter.Update,
the SQL table is updated but nothing is captured in SQL
Profiler. Why?
 
Hi Dave,

I cannot reproduce the problem you experienced. Please try to check if you
SQL Profile is properly configured. When you create a new trace in it,
please check the Events and Filters tab to see if what you want to trace is
in the list.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| Content-Class: urn:content-classes:message
| From: "Dave" <[email protected]>
| Sender: "Dave" <[email protected]>
| Subject: ADO.NET not in SQL Profiler?
| Date: Tue, 14 Oct 2003 20:16:57 -0700
| Lines: 6
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOSysqmiCp0gA3WQLWMpu+G3FECbg==
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:63669
| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| When I use SQLDataAdapter to fill a dataset, the select
| statement appears in SQL Profiler.
|
| When I update the DataSet using SQLDataAdapter.Update,
| the SQL table is updated but nothing is captured in SQL
| Profiler. Why?
|
 
You are correct. I was missing the Stored Procedure -
RPC:Starting/Completed events. Thanks!
 
Hi Dave,

I'm glad to know that you've got this problem resolved.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| Content-Class: urn:content-classes:message
| From: "Dave" <[email protected]>
| Sender: "Dave" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: ADO.NET not in SQL Profiler?
| Date: Thu, 16 Oct 2003 14:53:23 -0700
| Lines: 58
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOUL+tpRA24JBK+QCaA+ZRMzkY2Qw==
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:63819
| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| You are correct. I was missing the Stored Procedure -
| RPC:Starting/Completed events. Thanks!
|
| >-----Original Message-----
| >Hi Dave,
| >
| >I cannot reproduce the problem you experienced. Please
| try to check if you
| >SQL Profile is properly configured. When you create a
| new trace in it,
| >please check the Events and Filters tab to see if what
| you want to trace is
| >in the list.
| >
| >If anything is unclear, please feel free to reply to the
| post.
| >
| >Kevin Yu
| >=======
| >"This posting is provided "AS IS" with no warranties,
| and confers no
| >rights."
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Dave" <[email protected]>
| >| Sender: "Dave" <[email protected]>
| >| Subject: ADO.NET not in SQL Profiler?
| >| Date: Tue, 14 Oct 2003 20:16:57 -0700
| >| Lines: 6
| >| Message-ID: <[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| Thread-Index: AcOSysqmiCp0gA3WQLWMpu+G3FECbg==
| >| Newsgroups: microsoft.public.dotnet.framework.adonet
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.dotnet.framework.adonet:63669
| >| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| >| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| >|
| >| When I use SQLDataAdapter to fill a dataset, the
| select
| >| statement appears in SQL Profiler.
| >|
| >| When I update the DataSet using SQLDataAdapter.Update,
| >| the SQL table is updated but nothing is captured in
| SQL
| >| Profiler. Why?
| >|
| >
| >.
| >
|
 
Back
Top