asked on

SQL 2016 Connecting to Visual Fox Pro

I am trying to use the Import 32 Bit Data Wizard as I need to connect to a Visual Fox Pro Database, is this Possible, I was able to do this using SQL 2008, we have since upgraded our SharePoint Infrastructure and need to be able to read that data in?

John

HainKurt

what are you trying to do actually?

you have a fox pro db, and
want to connect, import data into sql server
and get rid of fox pro db?

or what?

pepps11976

ASKER

We have a foxpro database which we would like to extract the data from say every 10 minutes into SQL which is the base for our Sharepoint and then use business intelligence to report on it.

The sharepoint part is fine I'm just struggling trying to find a driver to connect to the foxpro so I can get the information

John

ASKER CERTIFIED SOLUTION

HainKurt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pepps11976

ASKER

But surely I need a compatible driver to connect

HainKurt

it is easy to test right... grab the driver, install, add a linked query to foxpro
and do some select from linked server and see how it works...
if all selects are ok, then write sp, add a job and point it to your sp...

pepps11976

ASKER

I think the problem that I am having is finding a driver for server and sql 2016

SOLUTION

Olaf Doschke

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Olaf Doschke

There only is this one OLEDB provider for VFP data and it's sufficient for any version of VFP DBFs and any SQL Server version supporting OLEDB data sources, which is pretty much any SQL Server (32bit) version.