I have a job that uses the visual fox pro oledb data provider to connect into a visual fox pro database and import data into sql server. It runs fine in sql 2008. I have a new server with SQL Server 2012. I installed the VFP provider on it as well. I went back in through the import wizard (how I set up the job on the original server) and tried to create it. I see the VFP provider in the drop down under data source. However when I go to click properties it just freezes in the import wizard and I have to kill it through task manager. Any idea why this would be happening?
- Changed type ArthurZMVP, Moderator Tuesday, February 26, 2013 2:20 AM revised to reflect the thread intent
I suspect the SQL Server Native Client 11 you use in the Data Export Import Wizard is not willing to support this VFP.
I think you may need to use a lower version of SQL Native Client to extract the data into an intermediate media (think file).
Arthur My Blog