Post reply

Query or create linked server to FoxPro Free Tables?

  • August 10, 2009 at 1:43 pm

    #156087

    So I want to make a report over a FoxPro database table FPTable.dbf that resides on ServerB. My SQL 2005 is on ServerA.

    I've tried using an openquery and also the instructions to make a linked server from:

    http://www.eggheadcafe.com/forumarchives/SQLServerconnect/Aug2005/post23124828.asp

    I've installed the latest FoxPro OLE DB drivers on all machines involved and it still gives me errors about VFPOLEDB.dll not loaded.

    Any suggestions?

  • August 11, 2009 at 8:24 am

    #1037465

    I've kind of found an answer. Since I was going to use it for a report anyway here's what I did and it works:

    The data source is of type ODBC with the following connection string -

    Driver=Microsoft Visual FoxPro Driver;sourcedb=\\server\directory;sourcetype=DBF;exclusive=No;backgroundfetch=Yes;collate=Machine;null=Yes;deleted=Yes

    This is for a free table style FoxPro database. For those of you who have a .dbc I've no idea how to help you, sorry!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply