If you are trying for a SQL server, use the system stored procedure:
EXEC sp_who
It will give you all the information on who is connected and what they are doing.
Good luck.
The ADODC has a nifty little property called the Filter.
I am assuming that the 3 selection criteria are static, right? You don't have to probe the db for the list of Subjects, right? So all of the list/combo boxes could be set up ahead of time. The ADODC.Filter is like a micro query. You...
I assume that you are using an ADODC, right?
Right up to a point:
TextBox1.Text = QuestionCount
needs to be
TextBox1.Text = Data1.Recordset("QuestionCount")
Also, make sure that your ActiveConnection is connected to the database :) Those are the two real keys to ADO connections :)...
Btw, I am using WMI to check the active processes for a name = "sqlservr.exe" I just discovered WMI today, what a badass replacement for API's....
Do a search for WMI on msdn.
I can get a list of the servers on an NT network using the:
Private Declare Function NetServerEnum Lib "netapi32"
That is dandy, but this does not pick up the (local) server that I have seen in many other dropdowns. The problem comes in the form of a notebook.
Connected to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.