Re: OLE error 80040E21 reading BIGINT using AsFloat

On 9/12/2006 4:29:16 AM, "Guillem" wrote:

my suggestion: check if the OLE DB provider is the same you have on
those computers where it works.

Also check if the MDAC version is the appropiate and/or is broken in
those computers where it fails. For this you can use

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4
B43-BF53-14332EF092C9&displaylang=en

or

http://tinyurl.com/62nvo

For example, it could be you have MDAC 2.8 SP1 installed on the
machines where it works and MDAC 2.8 on the machines where it doesn't
work. There is really a difference if the SP is installed or not, as we
discovered some time ago... sigh

Also check my reply to John. I hope something of all this can help you


Thanks for the link to the component checker. I'd not seen that before
and I think it will be really useful. I saw your reply to John and might
try that, but reading the data using AsVariant into a Real variable seems
to have worked. Again, thanks for your help.

Dan
.

Relevant Pages

  • Re: A DLL gone bad ?
    ... See the link below for info on XP SP1 & 2 with the MDAC stuff. ... Both computers have XPPro and Service Pack 2 on them. ... I tried running Windows Update - it tells me that it's all up ... Perhaps I need to try to install Service Pack 2 itself (again - even ...
    (microsoft.public.vb.general.discussion)
  • Re: Crash VB6 on SP2 Mdac2.8?
    ... I suspect that the version of MDAC your program is designed to use is not ... Run Component Checker ... SP2 introduces a number of interesting side-effects that might also be ... > because it runs excellent on Win98 and Win2000 computers. ...
    (microsoft.public.vb.database)
  • Re: OLE error 80040E21 reading BIGINT using AsFloat
    ... I think I'll try reading the data using ... those computers where it works. ... it could be you have MDAC 2.8 SP1 installed on the ... machines where it works and MDAC 2.8 on the machines where it doesn't ...
    (borland.public.delphi.database.ado)
  • References - Standardize MDAC?
    ... I'm having problems with broken/missing references when different ... computers on the network open up an Access 2000 application. ... find and use a machine to develop on that has the lowest MDAC ... standardizing MDAC on each computer makes the most sense to ...
    (microsoft.public.access.formscoding)
  • MDAC 2.7 with Win XP SP2
    ... I have two computers one has MDAC 2.7 on Win XP SP1 the other computer ... has MDAC 2.8 SP1 on Win XP SP2. ...
    (microsoft.public.data.ado)