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.
Book Description
Frequently Bought Together
Editorial Reviews
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
Would you like to update product info or give feedback on images?
|
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
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,
By Carla Fair-Wright "avid reader" (Houston, TX USA) - See all my reviews
This review is from: Client-Server Applications with Visual FoxPro and SQL Server (Paperback)
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.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
"In the beginning, there were mainframes and minicomputers." Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
local data engine, using remote views, source control software, server data types, data handler, remote data source, declarative referential integrity, multiple result sets, clustered index, database container, recordset object, pubs database, timestamp column, connection handle, domain integrity, northwind database, implicit transactions, stored procedures, shared locks, update lock, explicit transaction, update conflicts, identity columns, named connection, insert triggers Key Phrases - Capitalized Phrases (CAPs): (learn more)
Upsizing Wizard, Enterprise Manager, Visual Basic, Server Profiler, Server Books Online, View Designer, Extending Remote Views, Microsoft Visual, Data Objects, Query Analyzer, Data Source Administrator, Connection Designer, Microsoft Windows, Performance Monitor, Server Agent, Social Security, Command Window, Event Class, Microsoft Access, Microsoft Data Engine, Database Properties, Import Wizard, Microsoft Office, Microsoft Transaction Server, Quarterly Orders New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
"In the beginning, there were mainframes and minicomputers." Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
local data engine, using remote views, source control software, server data types, data handler, remote data source, declarative referential integrity, multiple result sets, clustered index, database container, recordset object, pubs database, timestamp column, connection handle, domain integrity, northwind database, implicit transactions, stored procedures, shared locks, update lock, explicit transaction, update conflicts, identity columns, named connection, insert triggers Key Phrases - Capitalized Phrases (CAPs): (learn more)
Upsizing Wizard, Enterprise Manager, Visual Basic, Server Profiler, Server Books Online, View Designer, Extending Remote Views, Microsoft Visual, Data Objects, Query Analyzer, Data Source Administrator, Connection Designer, Microsoft Windows, Performance Monitor, Server Agent, Social Security, Command Window, Event Class, Microsoft Access, Microsoft Data Engine, Database Properties, Import Wizard, Microsoft Office, Microsoft Transaction Server, Quarterly Orders New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
This book cites 1
book:
1
book
cites this book:
- in Front Cover, Front Matter, and Copyright
- Hacker's Guide to Visual FoxPro 7.0 by Tamar E. Granor on page 355
Books on Related Topics
(learn more)
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
