I'm trying to use the VFP OLEDB driver on windows 7 machine with SQL2005 and SQL2008 with the Import data wizard. I have .Net 4, extended and client installed
Both versions correctly import from Excel and text files
When I choose VFPOLEDB driver and click properties button I get
"Unexpected Unrecoverable Error" instead. The three buttons - Abort, Retry, and Ignore
From the internet I've found that there is a problem with
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe.config
I've removed the .NET 4.0 entry and just have the .NET 2 entry in DTSWizard.exe.config.
I've reinstalled .Net 4 as well.
I wouldn't mind using ODBC either but import wizard only shows OLEDB connections.
I've created an SIS package that uses the VFPOLEDB driver, not without its problems (memory leaks I think) but for my basic use worked.
However I really a point and click way of importing dbf files, its no tproduction code just ad-hoc work.
There is no C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe.config so what does SQl2005 use?