RS.Open vs. Conn.Execute

Results 1 to 2 of 2

Thread: RS.Open vs. Conn.Execute

  1. #1
    Join Date
    Dec 1969

    Default RS.Open vs. Conn.Execute

    Is there any rule of thumb for when to use which, RS.Open or Conn.Execute? I see both used all over the place. Is it just personal preference or is there more to it? I haven't found much on the topic. Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: RS.Open vs. Conn.Execute

    After reading stuff on Micrsofts web about connection pooling and implicit vs explicit calls, I stick with conn.exec. It forces you to explicitly open connections, so that they will be closed. Some implicit calls leave a connection open, and do not return them to the pool until after timeout. There is more on the MS website. Search under connection pooling. Don't know if this helps..

Posting Permissions

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