rs, cm, open connections

Results 1 to 2 of 2

Thread: rs, cm, open connections

  1. #1
    Domain Guest

    Default rs, cm, open connections

    If i use the following for a stored proc. do i need to create cm2, rs2, p2, and cm3,rs3 , p3 to use the same connection but DIFFERENT stored procs?<BR><BR>Set cm = Server.CreateObject("ADODB.Command")<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>Set p = cm.Parameters<BR>thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Depends

    Some people say it will be better to use different ones BUT some people would say if you have finished with one the close it and reuse it.<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts