I am using SQL SERVER 2000
and MDAC 2.7
Connection made are through System DSN
using SQL Server Drivers
************* CODE *****************
Dim objCmd
Dim objRS
Dim lng_Counter
Dim arrParam
g_strLastSP = strSP
Set objRS = server.CreateObject("ADODB.RecordSet")
Set...
I am using a command object to call a stored procedure which returns a recordset.
It works alright at times but sometimes comes up with this error -
3709 : The connection cannot be used to perform this operation. It is either closed or invalid in this context
How do i resolve this ?
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.