Re: -2147467259 Unspecified Error

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 10:42:43 -0700

ADO.NET has more control over the pooling behavior, but not as much as
ADO.NET 2.0 (due out next year).
With ADO "classic" you don't have as much control. However, if it's the
pool, there's no way to reset it without restarting the application that
owns it. However, you might try changing the Connection string (change the
"Application Name=<some string>") to get a new pool. I would also make sure
you're running the latest version (2.8 I expect) from
www.microsoft.com/data.

hth 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Terry" <anonymous@discussions.microsoft.com> wrote in message
news:D864EFBC-2179-4296-97ED-E0DA8176CF0A@microsoft.com...
> The current logic is open conenction, insert a record from a recordset,
close connection.  This happens about every 5 minutes, but it really depends
on the application use.  This is a Windows Forms application, without a user
interface.  The connection is only open a short period of time.  Once we
start getting the unspecified error, continues everytim the open connetiion
is tried.  Is there a way to clear the ADO, without stopping and restrating
the app?
>
> Thanks,
> Terry

Relevant Pages

  • Re: ADO control and SQL Session
    ... I defined my ADO in code Dimc xConnection As New ADODB.Connection ... I drag and drop the ADO control to a user form. ... I close the ADO record set connection ... The ADODC control exposes a .recordset property that is a reference to the ...
    (microsoft.public.vb.controls)
  • Re: ADO control and SQL Session
    ... In my testing, if I open a VBA form with ADO control, sp_who ... I closed the form,reopen it, the number of sql session ... I close the ADO record set connection ...
    (microsoft.public.vb.controls)
  • Re: Newbie - Creating ms access table from Visual Basic
    ... This is one more reason to use ADO library directly instead of control, ... connection, but it will be opened only in a case if your Data control ... If you do not want to use ADO ... >> not Open method of the recordset and option should be adCmdText, ...
    (microsoft.public.vb.database)
  • Re: Newbie - Creating ms access table from Visual Basic
    ... This is one more reason to use ADO library directly instead of control, ... connection, but it will be opened only in a case if your Data control ... If you do not want to use ADO ... >> not Open method of the recordset and option should be adCmdText, ...
    (microsoft.public.vb.database.ado)
  • Re: C++ support for ADO
    ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... data classes for working with ADO/OLE DB. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)