Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tried importing VFP table
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01476164
Message ID:
01476338
Views:
44
>>In any case, the error should be more descriptive, I believe.
>
>The 64 bit version of Windows 7 has broken probably half a dozen of my programs. Not sure about SQL Server.

Answer from MS Employee:

There is no 64-bit VFP OleDB provider. That is why we can't import data from VFP to a 64-bit SQL Server. The workaround in the link you provided won't work too, as it is using the VFP provider too. This can't work in 64bit SQL Server.

In order to work around the issue, we can firstly install a 32-bit SQL Server, import the data from VFP to this 32-bit SQL Server, and then synchronize the data from the 32-bit SQL Server to the 64-bit SQL Server.
This workaround is available too in other scenarios that there is no 64-bit provider and we are using 64-bit SQL Server.

If you have any more questions, please feel free to ask.

-------------------------------------------------------------------------------------
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/ad87945a-b47f-4ec5-941a-d2ec7b02be59

I also posted a short blog on this topic
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/think-carefully-which-sql-server-you-wan
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform