| :: store procedure :: show all messages | Post a New Message | Post a Reply |
 Re: store procedure | Post a Reply |
from: Myrtle Creek, OR
.SetProcedure("qaur")
Call .AddParameter("param1", "200401")
Call .AddParameter("param2", "200406")
I got this err msg:
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
How do I tell the grid to use command object? My original asp page would say:
Set conn = Server.CreateObject("ADODB.Connection")
conn.open strConn
Set cm = Server.CreateObject("ADODB.Command")
cm.CommandText = "qaur"
cm.CommandType = adCmdStoredProc
cm.ActiveConnection = conn
Set R = cm.Execute (RecordsAffected, Array(200401,200406), adCmdStoredProc)
Thanks for your help.