Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP + SQL 2008 ?
Message
From
19/02/2009 06:25:11
Guy Pardoe
Pardoe Development Corporation
Peterborough, New Hampshire, United States
 
 
To
17/02/2009 17:14:33
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01382510
Message ID:
01382838
Views:
85
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform