Hi everybody,
From SSMS SQL Server R2 I just wanted to try to import a VFP table using Import/Export Wizard. Got this interesting error on the very first step, though.
See attached.
----------------------
TITLE: SQL Server Import and Export Wizard
------------------------------
The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)
------------------------------
BUTTONS:
OK
------------------------------
===================================
===================================
Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)
------------------------------
Program Location:
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)
--------------------------
So, it's possible that VFP tables import is broken with R2.
If it's not broken, fix it until it is.
My Blog