Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oledb driver cannot be located on the Local machine
Message
From
26/01/2016 10:46:18
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01630206
Message ID:
01630229
Views:
67
>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform