Re: Getting OLE Error 800A0E7F



Guillem,

> have you tried to update your ODBC driver? I've found a reference to
I have the lastest version of the ODBC drivers (2 weeks old)

>You should also try updating your MDAC if it's not the latest version.
I will check and update if nessacery

> do you also call coUninitialize after ending the work? it could have
I do

Bert.

"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:xn0eb9b8j2f0ms000@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Bert Moorthaemer wrote:
>
>> Hi all!
>>
>> I have an application that retrieves and updates data from a back-end
>> database connected through the OLE DB ODBC driver.
>
> have you tried to update your ODBC driver? I've found a reference to
> this problem with MyODBC (for MySQL). You should also try updating your
> MDAC if it's not the latest version.
>
> for MDAC:
> http://www.microsoft.com/downloads/details...&DisplayLang=en
>
>>
>> I use the ADO components of D7 update 2
>> I have setup the connection to be used in non-asynch mode and I use
>> standard TADOQuery's to do the retrieval and updates. The update and
>> retrievals are done using threads (and yes I have called CoInitialize
>> when starting the execute loop)
>
> see below
>
>>
>> The problem is:
>> I regulary get this error: OLE Error 800A0E7F (which seems to be:
>> operation not allowed in asynch mode) This happens more on updates
>> than on retrievals. This error is directly followed by an access
>> violation. I have checked and double checked memory allocations and I
>> do not have any leaking going on.
>
> do you also call coUninitialize after ending the work? it could have
> something to do, as an update usually always comes after a retrieval
>
>
> --
> Best regards :)
>
> Guillem Vicens Meier
> Dep. Informatica Green Service S.A.
> www.clubgreenoasis.com
> --
> Contribute to the Indy Docs project: http://docs.indyproject.org
> --
> In order to contact me remove the -nospam
>


.



Relevant Pages

  • Re: Remote views problem
    ... I'm pretty sure MDAC 2.5 was the last version to have the VFP ODBC driver. ... This should be URL for the FoxPro ODBC install module: ...
    (microsoft.public.fox.vfp.dbc)
  • Re: ODBC security problem
    ... mode setting is ignored and windows authentication is always ... SQL Server ODBC Driver Ignores Authentication Setting ... You can use component checker to verify the version and MDAC ...
    (microsoft.public.sqlserver.odbc)
  • Re: ODBC Driver for MSProject
    ... on Microsoft ActiveX Data Objects 2.1 Library: ... in the VBA Editor: ... Tools / Reference... ... > Is there an ODBC driver for Ms Project? ...
    (microsoft.public.project.vba)
  • Re: odbc driver?
    ... it MDAC but it was previously referred to as Universal Data ... Access and you had the ODBC driver packs, ... MDAC and MDAC is part of the OS so most MS drivers are ... to install the ODBC driver to a Server 2003 R2 box. ...
    (microsoft.public.sqlserver.odbc)
  • Re: where do I download sql odbc drivers from?
    ... OK, if you don't have SQL Server on any of the machines, you need to get ... MDAC 2.6 at least, as Win2000 shipped with MDAC 2.5. ... This release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider, the Desktop Database Drivers ODBC Driver, or the Visual FoxPro ODBC Driver. ...
    (comp.databases.ms-sqlserver)