Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tried importing VFP table
Message
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Tried importing VFP table
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01476164
Message ID:
01476164
Views:
231
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
Next
Reply
Map
View

Click here to load this message in the networking platform