Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to VFP database in 64bit Windows
Message
From
08/09/2010 10:40:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Connecting to VFP database in 64bit Windows
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01480573
Message ID:
01480573
Views:
256
I have an AutoCAD ObjectARX (C++) and .NET (C#) application that connects to both Access via the JET engine and VFP databases via the VFP OLEDB driver (vfpoledb.1). In 64bit Windows there is now a 64bit Access driver available so I just need to modify the C++ code to use that driver instead of the old one, a simple change to a connection string. The problem is that there is no such 64bit driver available for FoxPro. Microsoft's "solution" is 'run it in 32bit mode', see Ximy's reply at http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/6bcde49e-1532-4e87-aef3-ee24cbc18225, Cindy Winegarden's reply at http://www.vistax64.com/vista-general/22170-odbc-vista-foxpro.html and Cetin's reply at http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/thread/272f47cf-a02a-4aa4-b4e5-a345921b9553 ("You can't access VFP data over VFPOLEDB using 64 bits calls. However, you can use VFPOLEDB in 64 bits OS (provided calling party is not 64)")

Unfortunately this doesn't work for AutoCAD addins since 32bit AutoCAD cannot run on 64bit Windows, my AutoCAD addin MUST be a 64bit process.
Can anyone suggest a solution?
Next
Reply
Map
View

Click here to load this message in the networking platform