|
Client-Server Applications with Visual FoxPro and SQL Server | 
 enlarge | Authors: Leslie Koorhan, Chaim Charon
Publisher: Hentzenwerke Publishing
Category: Book
Buy New: $49.95
New (1) Used (7) from $20.83
Rating:  1 reviews
Sales Rank: 704694
Media: Paperback
Number Of Items: 1
Pages: 230
Shipping Weight (lbs): 1.1
Dimensions (in): 9 x 7.1 x 0.7
ISBN: 1930919018
EAN: 9781930919013
ASIN: 1930919018
Publication Date: October 2000
Availability: Usually ships in 2 to 4 weeks
| |
| Similar Items:
|
| Editorial Reviews:
Product Description
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.
|
| Customer Reviews:
Easy to read but leans toward the technical September 27, 2006
1 out of 1 found this review helpful
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.
|
|
|
| |
