Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP + SQL 2008 ?
Message
De
19/02/2009 06:25:11
Guy Pardoe
Pardoe Development Corporation
Peterborough, New Hampshire, États-Unis
 
 
À
17/02/2009 17:14:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01382510
Message ID:
01382838
Vues:
84
>Hi
>Your opinion about this combination
>
>Thanks
>Carlos Burgos


Hi Carlos,

I use VFP and SQL 2008. From the VFP point of view, there are hardly any differences between SQL 2005 and SQL 2008. One notable exception is SQL 2008 now has a date datatype that you can use instead of having to use a datetime field.

There are some quirks if you're using the newer nChar and nVarChar datatypes instead of Char and VarChar, and depending on which driver you're using, SQL Server ODBC versus SQL Native Client (OLE-DB), you have different levels of success with those fields types.

I recommend SQL Server 2008 and using the older SQL Server ODBC driver with VFP. And just to make your life easier, I also recommend staying away from nChar and nVarChar datatypes if you can avoid it.

SQL Server 2008 is a great product.

Guy
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform