Enumerate ODBC System records

By calling CDatabase::OpenEx(NULL, CDatabase::forceODBCDialog)
you get the ODBC DSN Control panel selection screen thingy to choose from.
That screen has File, System and perhaps more tabs on them
I want to not go through that selection window, instead only enumerate the
System DSNs in my own app.
I know this info is stored in the windows registry, but I'm looking to do
this using the right way: documented API's.
Any idea ?
LisaTake a look at the SQLDataSources API. This will allow you to enumerate the
DSNs.
HTH
--
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@.m_ with @. to reply.
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:OjuNz$02DHA.1760@.TK2MSFTNGP10.phx.gbl...

quote:

---

> By calling CDatabase::OpenEx(NULL, CDatabase::forceODBCDialog)
> you get the ODBC DSN Control panel selection screen thingy to choose from.
> That screen has File, System and perhaps more tabs on them
> I want to not go through that selection window, instead only enumerate the
> System DSNs in my own app.
> I know this info is stored in the windows registry, but I'm looking to do
> this using the right way: documented API's.
> Any idea ?
> Lisa
>

---

EnterpriseManager-->Process Info Screen

SQL 2000 SP3
================================================

In reviewing this screen, I have SPIDS > 100 that have a status of
sleeping, command = AWAITING COMMAND and login/batch dates that are
weeks old ... Shouldn't this list be more recent activity only ?

Thanks,

Craig(csomberg@.dwr.com) writes:
> SQL 2000 SP3
>================================================
> In reviewing this screen, I have SPIDS > 100 that have a status of
> sleeping, command = AWAITING COMMAND and login/batch dates that are
> weeks old ... Shouldn't this list be more recent activity only ?

I guess that depends on what you expect on your site. If you have
developers who connect through Query Analyzer every once in a fortnight,
this is would display like this.

I don't know if that screen shows application, hostname and that, but
you can use sp_who2 or query sysprocesses directly to get this information.
This can give you an idea whether this is normal, or if something is
fishy.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items shown
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
--
Steven FergusonSteven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely to
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.com/sql_server_profiler_tips.asp
Hope this helps
John
"fergusons" wrote:
> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen under
> the Current Activity option in the Management folder there are no items shown
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items shown
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
Steven Ferguson
Steven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely to
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.co...filer_tips.asp
Hope this helps
John
"fergusons" wrote:

> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen under
> the Current Activity option in the Management folder there are no items shown
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items show
n
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
Steven FergusonSteven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely t
o
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.c...ofiler_tips.asp
Hope this helps
John
"fergusons" wrote:

> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen und
er
> the Current Activity option in the Management folder there are no items sh
own
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson