When I upgraded ADO from 2.1 to 2.5 I got a HUGE Performance Decrease with
Asynchronous Operations. In fact it doesn't really behave asynchrounously
anymore. On a WinNT Box when I uninstalled 2.5 (with CC), the performance
went back to normal.
The other odd thing is that Commands that I don't execute Asynchronously
(set myRS = cmd.Execute) still Raise the cn_ExecuteComplete Event. I don't
remember this happenening with 2.1.
1. Ideally I would like my performance back with ADO 2.5. Can someone
please point out the ridiculous mistake I am making? I am fairly positive
it is my fault. See Sample Code Below.
2. Is there anyway to uninstall ADO 2.5 on Win2K. I tried using the the
"C:\ComCheck\ComCheck /D" However, after I run it, I never see the
"Reconfigure ..." Option like I did on WinNT 4.0?
Thanks in advance,
Dim WithEvents cn as Connection
Dim cmd as Command
Dim myCString as String
Public Sub Class_Initialize
set cmd = new Command
set cn = New Connection
myCString = "Whatever"
cn.ConnectionString = myCString
cmd.name = "MyCommand"
cmd.CommandType = adCmdStoredProc
Set cmd.ActiveConnection = cn
Public Sub RunMyCommand()
Dim sCommandTxt As String
sCommandTxt = "GetDataWithMySP"
cmd.CommandText = sCommandTxt
Call cmd.Execute(, , adAsyncExecute)
Private Sub cn_ExecuteComplete( **Deleted for brevity**)
If pCommand.Name = "MyCommand" then Debug.Print " Hey I am Finished"