Re: Connection State

From: Ashok K Kumar (AshokKKumar_at_discussions.microsoft.com)
Date: 12/20/04

Next message: Ashok K Kumar: "Re: ADO Parameters error"
Previous message: Stuart Carnie: "Re: When can I use transactions in VB6 / ADO 2.8?"
In reply to: Carl Brennan: "Connection State"
Next in thread: Stephen Howe: "Re: Connection State"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 20 Dec 2004 23:07:00 +0530

What is the version of the ADO? Check the version of msado15.dll in the
program files\common files\system\ado folder.

-- 
_____________________
Ashok K Kumar
ashokkal at gmail dot com
"Carl Brennan" <CarlBrennan@discussions.microsoft.com> wrote in message 
news:EC0E5D90-ABB7-4143-A2E8-8BFABAF908E7@microsoft.com...
> We are experiencing a strange problem with the ADO Connection State 
> Property.
>
> When we close the connection the state is set to 0 as expected.
> Following the close statement we attempt to reopen the database connection
> to a database we know is unavailable.
>
> Using XP Service Pack 2 the open call returns and the state is set to 0.
> However, using XP Service Pack 1 or Windows 2000 SP4 the state is set to 1
> even though the connection is not open.
>
> What is going on??????
> What was fixed in XP SP2 that addresses this and is there a fix for Win 
> 2000?
>

Next message: Ashok K Kumar: "Re: ADO Parameters error"
Previous message: Stuart Carnie: "Re: When can I use transactions in VB6 / ADO 2.8?"
In reply to: Carl Brennan: "Connection State"
Next in thread: Stephen Howe: "Re: Connection State"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

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)
Re: ODBC/OLE DB Connection Pool
... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
(microsoft.public.data.ado)
Re: ODBC/OLE DB Connection Pool
... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
(microsoft.public.inetserver.asp.db)
Re: ODBC/OLE DB Connection Pool
... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
(microsoft.public.data.oledb)
Re: How to make the app run?????
... throwing an error if the connection never was opened, ... How can i tell if i'm using ADO as in VB or .Net ADO ?? ... First of all, it was not shown to my customer, I took it to a very nice ... How do you get in "installed" on client computer? ...
(microsoft.public.dotnet.general)