>Hi Dimitry. Thanks for your reply
>Think I know what issue is now
>A few months ago, app was coming up with OutOfMemory errors so compiled it as 64 bit and this cleared the OutofMemory messages, but I think VfpOleDB driver is not compatible with 64 bit
>(At the time, the bit using OleDb was not required so ws never tested)
>
>So now, I need 64 bit but cannot run the VfpOleDb driver
>Is there an alternative, that will import VFP tables, and also run in 64 bit ?
Perhaps you can do that from within SQL, using the ODBC driver to connect to your tables as a connected server. Should also be possible to do from within 64-bit SQL... don't know how that one worked but I've seen it done. A driver should be available at
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b and the line in SQL should be something like
SELECT * FROM openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceDB={path to your}.DBC;SourceType=DBC','select * FROM {your table here}'
You need to install the MSDASQL stuff first, which may be forbidden by local security... tricky and may not work everywhere. Also, the path should be relative to SQL server, i.e. a full path accessible by the account under which the service runs, possibly an UNC, check the rights. Posting this just in case nothing else works.