Search results for query: *

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.

btw, we ended up going with MSDE/SQL and a VB front end. MSDE for the small/cheap people and SQL for the bigguns. :)

http://msdn.microsoft.com/library/en-us/dnmsde/html/msdeforvs.asp

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...