Client-Server Applications with Visual FoxPro and SQL Server [Illustrated] (Paperback)

~ Leslie Koorhan (Author), Chaim Charon (Author) "In the beginning, there were mainframes and minicomputers..." (more)
Key Phrases: local data engine, using remote views, source control software, Upsizing Wizard, Enterprise Manager, Visual Basic (more...)

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.

About the Author

Chuck Urwiler is a senior instructor, consultant, and developer for Micro Endeavors, Inc., a Microsoft Solution Provider Partner and Certified Technical Education Center in Upper Darby, Pennsylvania. Gary DeWitt has been a frequent contributor to FoxTalk and FoxPro Advisor magazines and was the technical editor of Developing Internet Applications With Visual FoxPro 6.0. Michael Levy is a consultant with G.A. Sullivan, where he specializes in SQL Server and database technologies. Leslie Koorhan is an independent consultant and trainer specializing in database applications. He has worked with nearly every version of FoxPro and Visual FoxPro, as well as Microsoft SQL Server since the mid '90s. He is also a Visual Basic developer. He has written numerous articles for several publications, most recently a series on Microsoft SQL Server OLAP Services for FoxTalk magazine.

Product Details

• Paperback: 230 pages
• Publisher: Hentzenwerke Publishing; illustrated edition edition (October 2000)
• Language: English
• ISBN-10: 1930919018
• ISBN-13: 978-1930919013
• Product Dimensions: 9 x 7.1 x 0.7 inches
• Shipping Weight: 1.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
• Amazon.com Sales Rank: #1,164,594 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #23 in

  Books > Computers & Internet > Microsoft > Applications > Visual FoxPro

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

4.0 out of 5 stars Easy to read but leans toward the technical, September 26, 2006

By	Carla Fair-Wright "avid reader" (Houston, TX USA) - See all my reviews

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.