Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tried importing VFP table
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01476164
Message ID:
01476338
Vues:
46
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform