I got a big sp that i have to run that take up to hours. I need is to find a way to run a sp beside doing
Dim cmd As New OleDbCommand
Dim Dr As OleDbDataReader
Dim Conn As OleDbConnection
sSQL = "exec Import_Process_DataEntry_RO " & Session("opid")
cmd = New OleDb.OleDbCommand(sSQL, Conn)
and it times out and crashes the web site. It looks like it does go on running the sp but im not really sure if its right. or not
I can build my own tracking mechanizm just using track tables and stuff but i do need it to run by it self. so the page wont time out. Is this possible thank you.