Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Import Wizard - Unexpected Unrecoverable Error Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 5:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:21 AM
Points: 92, Visits: 373
Hi

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

[url=http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e8be2b2a-57f9-485e-90df-2f857f3a0c55][/url]

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?
Post #1376412
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse