>Hello Tom
>
>thanks for your codes
>
>tried your codes but i found an error while connection
>
>nAccess=SQLSTRINGCONNECT(IcConnetionStr)
>
>Error is that "SQLSTRINGCONNECT.PRG DOES NOT EXIST"
The most likely explanation is that the version of VFP you are using does not implement the command - SQLSTRINGCONNECT() is a native VFP function in both VFP 5 and 6; the question is what version of VFP or FoxPro are you using? It's definitely not a part of the now discontinued FPW and FPDOS products, and I'm not sure if it was implemented in VFP 3 (I don't have VFP 3 installed here to check.) If you're using one of these older products, you will have to upgrade to a more current product version to use this command, and this may entail significant revision of your app to run under the newer version of VFP.
FPW and FPDOS apps are definitely require significant rewrites to run under VFP; you might consider writing standalone executables to implement importing and exporting data using a current version of VFP supporting SQLSTRINGCONNECT() and the other ODBC functionality you need, and either calling them as standalone executables using the RUN command, or if you are using FPW, writing a set of functions to implement required operations in VFP as a DDE server, and using DDE to pass data and execute commands between your FPW app and the new code in the VFP-based DDE server. While developing a DDE server and implementing DDE exchanges is not a trivial project, it may be easier than doing a complete rewrite in VFP, especially when the work is isolated and can operate through a simple, well-defined interface. DDE works with the Windows platform; it isn't available to FPDOS.
DDE allows conversations between a DDE server and a client; the exact details of the exchanges must be defined in detail in the DDE server. You may be able to access the VisualFoxPro.Application COM object indirectly using the FPOLE.DLL interface library, which exposes the COM server via a wrapper DLL supllied with VFP, but I've never tried to use it with FPW; I have used it to access VFP functionality from Win32 application development platforms that supported the standard C-style DLL interface, but did not have COM support.