Tarfumes.com - Client-Server Applications with Visual FoxPro and SQL Server

List Price: $49.95
Our Price: $49.95
Availability: Usually ships in 2 to 4 weeks
Manufacturer: Hentzenwerke Publishing

Average Customer Rating:

Binding: Paperback
EAN: 9781930919013
ISBN: 1930919018
Label: Hentzenwerke Publishing
Manufacturer: Hentzenwerke Publishing
Number Of Items: 1
Number Of Pages: 230
Publication Date: 2000-10
Publisher: Hentzenwerke Publishing
Studio: Hentzenwerke Publishing

Related Items
MegaFox: 1002 Things You Wanted to Know About Extending Visual FoxPro What's New in Nine: Visual FoxPro's Latest Hits Deploying Visual FoxPro Solutions 1001 Things You Always Wanted to Know About Visual FoxPro WebRAD: Building Database Applications on the Web with Visual FoxPro and Web Connection

Editorial Reviews:

Visual FoxPro is the perfect front end for client-server applications. Its robust user interface, native local data engine and integral hooks into binding with remote data sources, and rich object model, combined with the powerful SQL Server database engine are an unbeatable combination. But with power and flexibility comes potential complexity. Client-Server Applications with Visual FoxPro and SQL Server teaches users how to put these two powerful tools together and take advantage of the best features of both.

Spotlight customer reviews:

Customer Rating:

Summary: Easy to read but leans toward the technical
Comment: This book provides one of the best references available for integrating Visual FoxPro and SQL Server. There are few guides for the Visual FoxPro Developer in how to create multi-user applications in Client/Server Mode. Urwiler, Dewitt, Levy, and Charon have teamed up to write a book that fills a large gap in the VFP to SQL Server integration area. The book provides a step-by-step process that is simple enough in format to understand and basic enough to put in practice with little previous SQL Server experience. The authors begin with a quick overview of client/server, basic database design and theory before moving into the more complex tasks of upsizing and connectivity.

There are plenty of code examples and appropriate illustrations. As a book targeted towards the VFP programmer the authors do a fairly good job. The four coauthors provide tips and point out problem areas and pitfalls to avoid. There are helpful hints for using GenDBC a utility program the ships with VFP to refine remote views. While the book covers the entire subject of integration well, the better features of interest are the contrast and comparing of VFP and SQL Server database architecture. Some of the book's best sections of interest include:

Using SQL Server Security
Connecting to the Database Server with Remote Views
Working with ODBC
Optimizing View Performance
Connecting to the Database Server with SQL Pass-Through

Once you finish reading the book, many of the your questions regarding SQL Server integration will be answered. This book is a great introduction to SQL Server. But for the more complex operations of performance tuning and optimizing, there are better books available.

The book is easy to read but leans toward the technical. Be warned this is a technical book and while some technical books not only instruct but entertain. This is not one of them. This is written in a no nonsense and get-down-to-business style. If you want a light read look else where, but if you need to upsize your VFP database and do it quickly look no further.

More Reviews