Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VfpOleDB ALTERNATIVE
Message
From
18/10/2022 07:31:02
 
General information
Forum:
Visual FoxPro
Category:
Web Services
Miscellaneous
Thread ID:
01685089
Message ID:
01685101
Views:
57
Gerard,

Was asked that looong time ago, found & saved Link
https://www.dlldownloader.com/vfpoledb-dll/
as methods described there sounded not too illogical,
but never had reason to try out the things there.

WARNING: such sites offering dll downloads as well MIGHT be serving MALWARE
I have NOT VERYFIED anything!
Use only .Dll you are certain to be clean & from trusted sources
with typing out installation commands you read in advance and understand
Paranoid me would spin up a new clean 64 bit VM and try it there

If testing one or more of the myriad ways described,
pls. give feedback on results of methods tested on which 64 version(s) of Win.

But first get a clear picture of the basics involved:
If the web app is Dotnet compiled as "x86" you should have no problems,
dunno if above works with "anycpu" which on 64b needs marshalling bits,
so verify the compilation target ASAP and search if DllHost has advanced enough by now..

https://microsoft.public.fox.programmer.exchange.narkive.com/NCHFwrvg/vfpoledb-64-bit-operating-systems
from 17 years ago has me butting in (newer development might offer better solutions)
but offers at least another COM based solution via COM Exe which should span 32/64 differences,
but introduces even more extensive/costly COM process marshalling
for every data access, which might kill any advantage vfp gives you speedwise.

COM calls across Exe bitwise boundries were available umpty years ago.
But my gut hint would be to compile as x86 unless overwhelming reason exists.

Mantra here as always: code chunky, not chatty!

HTH
thomas

>I have a web app that uses VFP tables (Written in Visual Studio)
>It was running fine on a 32 bit server, now it's been moved to a 64 bit server
>Looks like VfpOleDB does not work in this scenario
>Is there any alternative, or any way of making VfpOleDB driver to work on 64 bit machine ?
>Regards,
>Gerard
Previous
Reply
Map
View

Click here to load this message in the networking platform