Results 1 to 2 of 2

Thread: How to Clear ADODB Connection pool

  1. Jun 1st, 2012, 02:23 AM #1
    winman
    winman is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Posts
    248

    How to Clear ADODB Connection pool

    We have a VB.net application using both ADO.net and ADODB connections(both connecting to MS SQl server)
    Whenever an ADO.net connection throws an expection, we cleared the pools
    Now if any ADO.connection reopened and everything works fine
    Is there any way to clear pools for ADODB connection?
    Reply With Quote Reply With Quote
  2. Jun 1st, 2012, 07:47 AM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: How to Clear ADODB Connection pool

    Rather than clearing out the pool, perhaps you should be looking into what's causing the error and fixing that. Plus... why using the mix of ADO.NET and ADODB? Wouldn't it make sense to use one (ADO.NET) or the other?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width