pepps11976
asked on
Error connecting to Visual Fox Pro Database Using SQL Import and Export Wizard
Using SQL Server 2008 R2 and Using the SQL 32 Bit Import and Export Data to connect to a Visual FoxPro Database (this used to work Just Fine)
However when selecting Data Source and Choosing OLE DB Provider for Visual Fox Pro I get the following error
Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)
-------------------------- ----
Program Location:
at System.Data.OleDb.OleDbCon nectionInt ernal..cto r(OleDbCon nectionStr ing constr, OleDbConnection connection)
at System.Data.OleDb.OleDbCon nectionFac tory.Creat eConnectio n(DbConnec tionOption s options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.D bConnectio nFactory.C reateConne ction(DbCo nnectionOp tions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.D bConnectio nFactory.C reateNonPo oledConnec tion(DbCon nection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.D bConnectio nFactory.T ryGetConne ction(DbCo nnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.D bConnectio nInternal. TryOpenCon nectionInt ernal(DbCo nnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.D bConnectio nClosed.Tr yOpenConne ction(DbCo nnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.D bConnectio nInternal. OpenConnec tion(DbCon nection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbCon nection.Op en()
at Microsoft.SqlServer.Dts.Dt sWizard.DT SWizard.Ge tOpenedCon nection(Wi zardInputs wizardInputs, String connEntryName)
at Microsoft.SqlServer.Dts.Dt sWizard.St ep1.OnLeav ePage(Leav ePageEvent Args e)
can anyone assist like I said this worked fine in the past
However when selecting Data Source and Choosing OLE DB Provider for Visual Fox Pro I get the following error
Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)
--------------------------
Program Location:
at System.Data.OleDb.OleDbCon
at System.Data.OleDb.OleDbCon
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.OleDb.OleDbCon
at Microsoft.SqlServer.Dts.Dt
at Microsoft.SqlServer.Dts.Dt
can anyone assist like I said this worked fine in the past
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Author did not decide so it is in our hands...
I've confirmed your way of data import cannot work in your current configuration and I've also offered several possible solutions. Did you implement some of them? Do you need additional help with the data import?
Regards
Pavel