Windows multi-DBMS programming

John Taschek

Though there's a glut of books about client/server database programming and design, few attempt to tackle as many issues as Ken North's Windows Multi-DBMS Programming. His book, which was released last month, may be too broad for some tastes, but it's nevertheless worth its $49.95 price.

North, an established consultant and free-lance author of technical articles, deftly covers the major issues developers face when creating database applications. The book discusses major programming language products, including Borland International Inc.'s C/C++, Microsoft Corp.'s Visual C++ and Visual Basic, and Powersoft Corp.'s PowerBuilder. Code samples, which are included on disk, are used frequently to demonstrate major points.

After a brief overview of its contents, the 700-plus-page book goes into introductory chapters on Windows application-development issues and the concepts of database design.

North gets to the nitty-gritty in Chapter 5, in which he covers servers and database engines, such as Microsoft's SQL Server for Windows NT and Watcom International Corp.'s Watcom SQL. Strangely, however, North includes minor players such as Raima Corp. and Microrim, yet neglects to mention Oracle Corp., Sybase Inc., or Informix Corp., the three largest vendors of SQL database servers.

The point of the book, however, is not back-end database programming. It's database client-side application development, and on this subject the book excels.

Although the book is geared toward C++ and Visual Basic programmers, all Windows developers should read the chapters on ODBC (Open Database Connectivity) and Object Linking and Embedding, two subjects on which North is an acknowledged expert.

A compendium CD, which features 32-bit ODBC drivers, shareware versions of developer tools, and a benchmark kit, is $29.95.

NORTH'S BOOK is a must-read. -PC Week

Michael D. Reilly

Dozens of books cover a specific database package, but most treat their topic in isolation. Yet companies usually have more than one critical database, and rarely do all the databases run on one database management system (DBMS) or OS. Companies with multiple databases have tools for writing user interface applications that combine data from the databases. To produce useful, efficient applications, your challenge is to match the tools to the server database. Ken North's Windows Multi-DBMS Programming: Using C++, Visual Basic, ODBC, OLE2, and Tools for DBMS Projects helps meet that challenge for Microsoft Windows-based applications.

North starts with an introduction to Windows programming concepts and then discusses prevalent database architectures in the corporate environment. He quickly moves into the core topic of multidatabase programming, covering issues such as interoperability, gateways and routers, and distributed objects.

This how-to book reviews tools, explaining servers and database engines in detail, including Microsoft SQL Server, Watcom SQL, Quadbase SQL, R:BASE SQL, Raima's Database Server, Gupta SQLBase, and Integra VDB. The author selected these software packages because they all offer a SQL programming interface for Windows client applications. Nevertheless, the omission of products such as Oracle is surprising. The product descriptions are detailed, down to command strings for setting up databases, and instructions for using the DBMS software.

Open Database Connectivity (ODBC) is a major topic, and North gives it a lengthy chapter. It's a good introduction if you haven't worked with ODBC; even if you have, it's a good refresher course and reference. Qelib also gets an entire chapter. As with the OBDC chapter, plenty of reference tables and tips illustrate how to use Qelib. The other part of the client/server equation is choosing data access and data presentation tools. The author covers such tools as Microsoft Excel and Word, Lotus 1-2-3, Crystal Reports, and Gupta Quest. The chapter's comprehensive tables let you compare each tool's functions, features, and commands.

Moving from data access and presentation tools, the author explains developer-oriented tools, such as Asymetrix InfoModeler, AppWare, SQLView, and ProtoGen+, and how they help you design database applications. The next topic is client/server toolkits. The author discusses Powersoft's PowerBuilder, Gupta SQLWindows, and ObjectView, and points out that they can help integrate data from diverse sources.

You can use one category of software for standalone databases or as the client for larger databases. The two products that exemplify this category are Microsoft's Access and FoxPro. North points out some interesting benefits, including prototyping on a desktop and then moving the server component to a large DBMS. Developing client/server applications with these tools can reduce the amount of code you have to write. In a logical progression, the author then proceeds to programming tools such as Visual Basic (VB), C++, and Object Linking and Embedding (OLE) 2.0.

Windows Multi-DBMS Programming condenses a small library of useful information for database application developers. North compares tools without showing bias. For example, the tables listing available API calls can help you select the right tool for a specific purpose.

One criticism is that the section on server DBMSs misses the mark. Except for Microsoft SQL Server, the products North discusses do not seem to be affecting the corporate world. Gupta has allied with Microsoft, and Watcom with Sybase, to produce departmental rather than enterprise servers. This section would be more valuable it if covered methods of connecting to Oracle, Informix, Ingres, Sybase, and other industrial-strength databases. But if you want to stay in a Windows environment all the way, this book is a good place to start.

--Windows NT magazine

Windows Tech Journal

"Database Consultant's Survival Guide."