• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Sometimes you have stored proc that takes 2,3 or 5 min to execute. Application that lock up frequen

Sometimes you have stored proc that takes 2,3 or 5 min to execute. Application that lock up frequen

Sometimes you have stored proc that takes 2,3 or 5 min to execute. Application that lock up frequently frustrates users and waste their time

Rate Sometimes you have stored proc that takes 2,3 or 5 min to execute. Application that lock up frequen

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Set cmd = New ADODB.Command

        cmd.ActiveConnection = "DSN=test"
        cmd.CommandTimeout = 180
        cmd.CommandText = "sp_name"
        cmd.CommandType = adCmdStoredProc
        cmd.Execute , , adAsyncExecute'<--- start ASYNCHROUS

'You can also make a dumy progress bar to show proggres
Do While (cmd.State And adStateExecuting) = adStateExecuting
            DoEvents
Loop