Re: MDAC and open connections

SQLOLEDB provider means that i am not having an entry in the ODBC
Administrator. As we can enable tracing for a DSN entry in ODBC. Here in my
application i am not using an entry in ODBC but i am using ADO(SQLOLEDB). SO
do we have any option in WIN2K prof edition where all the calls to DB are
logged as in Tracing in ODBC ?
Hope its clear.

"Famel Lee" wrote:

> Yes, you use "General Statistics\UserConnections" to monitor the
> connections. And I belive this is provider indenpendent, it shows numbers of
> physical db connections no matter from what kind of provider. I am not sure
> what do you mean by logging SQLOLEDB provider. If you want to monitoring the
> sql statements issued to database, you can use Profiler to trace it.
>
> "Zombie" <Zombie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:119F7E66-5957-4D22-A6A4-8368BEBF3E53@xxxxxxxxxxxxxxxx
> > Famel
> > I belive "General Statistics\UserConnections" is one to be monitored . I
> am
> > correct ?
> > And i am using SQLOLEDB as the provider. Can the number of connections be
> > monitored if the application uses this SQLOLEDB provider?
> > And one more question, like enabling tracing for ODBC do we have any
> option
> > in WIN2K Pro where we get the complete log for SQLOLEDB?
> >
> > "Famel Lee" wrote:
> >
> > > If you are installing MS SQL Server, you will find "Performance
> Counters"
> > > options and you can use Performance Monitor to track open connections as
> you
> > > said.
> > >
> > > "Zombie" <Zombie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:91A045BB-1B2D-4146-84D6-33C3CEFE3B3E@xxxxxxxxxxxxxxxx
> > > > HI,
> > > >
> > > > I am looking for some help in finding a tool to keep track of number
> of
> > > opne
> > > > connection through MDAC .
> > > > Can perform.exe configured to meet this requirement ?
> > > > Thanx for the help
> > >
> > >
>
>
.

Relevant Pages

  • Re: MDAC and open connections
    ... You can use Profiler to trace all calls to the database. ... > SQLOLEDB provider means that i am not having an entry in the ODBC ... As we can enable tracing for a DSN entry in ODBC. ... >> physical db connections no matter from what kind of provider. ...
    (microsoft.public.data.ado)
  • HELP: Timeout Expired:
    ... has started throwing Timeout Expired errors after ... The application was developed using the SQLOLEDB provider. ... (Using ODBC for testing is fine, but I do not want to switch ...
    (microsoft.public.data.ado)
  • Re: Its been solved kinda...
    ... > doesn't seem to work without the use of the SQLOLEDB provider, ... Because ODBC has been deprecated, so you should be botching all of your DSNs ... (Reverse address to reply.) ...
    (microsoft.public.inetserver.asp.general)