Re: OLE error 80040E21 reading BIGINT using AsFloat

Dan Cumpian wrote:



I saw those on Google and they really didn't point to a specific
problem or workaround. I think I'll try reading the data using
AsVariant and see if that will solve the problem. I'm not sure what
else to try.

Thanks,
Dan

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

--
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: OLE error 80040E21 reading BIGINT using AsFloat
    ... 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 ... Also check my reply to John. ...
    (borland.public.delphi.database.ado)
  • 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: Delphi 7, TAdoConnection, Windows 2003 SP 1, MSDart.dll
    ... >> either a corrupted or incomplete or bad version of MDAC. ... >> The machines that I was dealing with happened to be xp machines which ... >> configuration and they had to do it. ... >>> Stefan Westner ...
    (borland.public.delphi.database.ado)
  • Re: How to revert from MDAC 2.8 to 2.7?
    ... That article, which point to the rollback, should work with MDAC 2.8 as ... > All of the machines are of identical hardware configurations, same OS, ... > And the MDAC install docs state that installing an older version will not ...
    (microsoft.public.data.ado)
  • Re: Access2000 to SQLServer2000 on an XP Nachine (sqlsrv32.dll)
    ... sqlsrv32.dll is part of MDAC. ... > I am having a problem connecting to my SQL server. ... A handful of Windows 2000 machines used to give ... > SQL Server Error: 0 ...
    (microsoft.public.data.odbc)