Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADODB Field Error: 80040e21
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00049707
Message ID:
00049776
Views:
70
>Hi, I was silly enough to install IE4 Preview 2 and now most of my active web pages refuse to read the VFoxPro files. I've narrowed the error down to numeric fields. It seems that IE4 PR2 can handle character fields without a problem but gives the ADODB Field Error 80040e21 when you get to a numeric field. I've looked through the registry and it seems that IE4 PR2 installed "ADODB 1.5" presumably replacing ADODB 1.0 (msado10.dll). Does anyone have the same problem? Can anyone suggest a fix other than changing all my numeric fields to characters?
>
>Rgds
>Petras

Petras,

I know of a numeric resolution problem accessing VFP tables via ADO. I found that the numeric width on the Foxpro table must be 1 digit more than the width of the largest numeric value you intend to store. ie:
maxvalue=9999 then make the VFP field width=5.

Not sure about the versions, I was using Visual Studio release of VFP and ASP. This error occured under Win95 PW Server, have not tested for the error under NT Server running IIS.

HTH
Mike
Michael McLain
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform