Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
64Bit SQL Server Access to Foxpro data
Message
From
08/09/2008 19:38:39
June Kendrick
Kendrick Associates, Inc.
New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Installation, Setup and Configuration
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345168
Message ID:
01345918
Views:
14
>Hi June,
>
>not sure if Guineu is up to your needs already, but with Guineu you can turn FoxPro functions into functions that can be called from stored procedures. The FoxPro code can access DBF files, use SEEK, SCAN, REPLACE, etc. There are some issues with that approach that you would need to check with your administrator. Because Guineu would access DBF files in the context of the SQL server, it must be granted a number of permissions that administrator might not give you.
>
This looks interesting. If they make at a 64-bit interpreter, it could be really interesting <g>

>Alternatively, you could create a VFP COM server as an EXE and then call it from your stored procedures. See http://www32.brinkster.com/srisamp/sqlArticles/article_31.htm for an introduction.

That might work with and EXE COM object, as it appears the problem is with 32-bit DLLs. The EXE's run in the WOW64 environment, and as that would be native FOX, not a DLL, it should work. I'll have to give it a try and see how it goes.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform