Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upsizing to SQL error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Database:
MS SQL Server
Divers
Thread ID:
01225443
Message ID:
01225447
Vues:
23
>>>Hi,
>>>
>>>When attempting to export a VFP Database to MS-SQL 2005 using the Upsize wizard I'm getting an error:"Error #10 in genbulkinserttextfile(0): syntax error".
>>>
>>>I've narrowed the problem down to a specific table. The table is created in MSSQL but no data is imported.
>>>
>>>I tried this on three databases with identical structure and one exported OK so I'm assuming the problem lies with the data content.
>>>
>>>I've tried the same thing with the Sedna CTP wizard and get basically the same error - except that it gives (2313) instead of (0).
>>>
>>>Any suggestions as to what the problem might be?
>>>TIA,
>>>Viv
>>
>>Check and fix your data
>
>Don't see any problem with the data - so what might need fixing?

2313 is error for difference in type of transfered data in our code
For example if you transfer Date, some of the data are correct but some is not in correct format, neverthless that you used Char field to store it for example.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform