vcgxa.htm

Visual C++与数据库的连接经典实例

<A NAME="E68E140"></A>

<H3 ALIGN=CENTER>

<CENTER>

<FONT SIZE=5 COLOR="#FF0000"><B>Books for Database Developers</B></FONT></CENTER></H3>

<BR>

<P><I>Microsoft Jet Database Engine Programmer's Guide</I> (Microsoft Press, 1996), by Dan Haught and Jim Ferguson, takes the programmer through the basics of the Microsoft Jet database engine and on to advanced topics. This book includes a CD-ROM that contains an online version of the book, code samples, and other valuable materials.

<BR>

<BR>

<A NAME="E68E141"></A>

<H3 ALIGN=CENTER>

<CENTER>

<FONT SIZE=5 COLOR="#FF0000"><B>Online Sources for Database Technical Support and Sample Applications</B></FONT></CENTER></H3>

<BR>

<P>The primary sources of technical support for Visual C++ database developers are the Microsoft-sponsored forums on CompuServe. Microsoft product support specialists (PSSs) answer developers' and end users' questions about Visual C++ and related Microsoft products. Developers and independent software vendors (ISVs) are regular participants in these forums. <I>Data Based Advisor</I> and <I>DBMS</I> magazines sponsor forums that cover a wide range of database-related topics. If you don't have a CompuServe account, call CompuServe at [phone] for a sign-up package.

<BR>

<P>In addition to a membership in CompuServe, you'll need a modem, a CompuServe access program (such as WinCIM), and the current version of PKWare's PKUNZIP.EXE application (or WinZip) to expand the files you download that are archived (compressed). Most archived files have an extension of .ZIP, although some archived files are available as self-extracting archive files with the extension .EXE. When you execute a self-extracting archive file, the file expands the individual files that it contains. Most archive files include one or more text files that document the contents of the archive and tell how to use the application contained in the archive.

<BR>

<P>The current version of the PKZIP utilities is available in Library 15 of the MSACCESS forum in the form of a self-extracting file, PK204G.EXE. The PKZIP utilities are shareware; if you use the PKZIP utilities you download, you're obligated to pay the registration and license fee specified by PKWare. The WinCIM program is available from CompuServe and other sources. It's sometimes distributed as an attachment to magazines and may be mailed free to CompuServe customers. You can reach CompuServe using a terminal program, but CompuServe is phasing out this support in an attempt to improve its system's efficiency. The Visual C++ 4 distribution CD has a copy of WinCIM. However, at the time this book was written, this version was out of date.

<BR>

<BR>

<A NAME="E69E326"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>The Client-Server Computing Forum</B></FONT></CENTER></H4>

<BR>

<P>Microsoft's Client-Server Computing forum (GO MSNET) is directed toward users of Microsoft LAN Manager and its extensions. This forum incorporates support for Windows NT Server.

<BR>

<BR>

<A NAME="E69E327"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>The Data Based Advisor Forum</B></FONT></CENTER></H4>

<BR>

<P>Advisor Communications International, Inc. sponsors the Data Based Advisor forum (GO DBA), a forum devoted to database topics. Library 14 of the DBA forum is devoted to Microsoft Access. Many of the applications described in <I>Access Advisor</I> magazine are available for downloading from the DBA forum.

<BR>

<BR>

<A NAME="E69E328"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>The DBMS Forum</B></FONT></CENTER></H4>

<BR>

<P><I>DBMS</I> magazine operates the DBMS forum (GO DBMS), which covers topics of general interest to database developers. Client-server database systems and SQL topics receive the emphasis in this forum.

<BR>

<BR>

<A NAME="E69E329"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>The EMS C/C++ Utilities</B></FONT></CENTER></H4>

<BR>

<P>The EMS C/C++ Utility Library is a collection of all freely distributable (public domain, freeware, shareware, contribution requested, demo code, and so on) source code, utilities, and applications for PC C/C++ developers. A directory database accompanying the library is a dBASE-compatible .DBF file with a DOS search program. The database also lists all existing commercial products for one-stop shopping for all existing C/C++ tools. The directory database and library are updated at least every two months. <I>C/C++ Users Journal</I> (February 1995) called it &quot;a comprehensive collection for one-stop shopping.&quot; In the May 1991 issue of <I>PC World,</I> Tom Swan said he was &quot;impressed with this one's quality&quot; and that &quot;the EMS library is a bargain hunter's dream.&quot; He went on to include extracts from the library to accompany his book <I>Learning </I><I>C++</I>.

<BR>

<UL>

<UL>

<P>EMS Professional Shareware Libraries

</UL></UL>

<UL>

<UL>

<P>4505 Buckhurst Court

</UL></UL>

<UL>

<UL>

<P>Olney, MD 20832

</UL></UL>

<UL>

<UL>

<P>Telephone: [phone]

</UL></UL>

<BLOCKQUOTE>

<BLOCKQUOTE>

<P>Fax: [phone]

<BR>

</BLOCKQUOTE></BLOCKQUOTE>

<BR>

<A NAME="E69E330"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>Independent Software Vendors</B></FONT></CENTER></H4>

<BR>

<P>Independent software vendors (ISVs) have their own sections of the Windows Vendors forums, coordinated by Microsoft. At the time this book was written, there were several ISV forums. Intersolv Software, for example, supports its ODBC drivers in the WINVEN D forum. Type GO WINVEN and then select the number corresponding to the forum you want to explore.

<BR>

<BLOCKQUOTE>

<BLOCKQUOTE>

<HR ALIGN=CENTER>

<BR>

<NOTE><B>NOTE</B>

<BR>

<BR>Forums on CompuServe change frequently. As a vendor becomes larger and more successful, the increased traffic warrants the creation of a new forum. If information for a vendor isn't where you expected it, check to see if the vendor has moved to a private forum.</NOTE>

<BR>

<HR ALIGN=CENTER>

</BLOCKQUOTE></BLOCKQUOTE>

<BR>

<A NAME="E69E331"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>The Macmillan Computer Publishing Forum</B></FONT></CENTER></H4>

<BR>

<P>Macmillan Computer Publishing, the parent organization of Sams Publishing, sponsors a CompuServe forum (GO MACMILLAN or GO PHCP). This forum provides information on books published by MCP subsidiaries under the imprints of Sams Publishing, Sams.net, Que, New Riders, Hayden, BradyGAMES, and Ziff-Davis Press. The libraries include lists of books available from MCP, tables of contents, sample chapters, sample files, sample programs, and other material extracted from MCP books. The message sections and libraries of the MCP forum are organized as shown in Table A.1.

<BR>

<BR>

<P ALIGN=CENTER>

<CENTER>

<FONT COLOR="#000080"><B>Table A.1. MCP libraries.</B></FONT></CENTER>

<BR>



<CENTER><TABLE  BORDERCOLOR=#000040 BORDER=1 CELLSPACING=2 CELLPADDING=3 >

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

<I>LibraryNumber</I>

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

<I>Library Name</I>

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

<I>Subject Matter</I>

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

1

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

General Library

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files of general interest

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

2

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

What's New

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

New stuff for this forum

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

3

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Graphics &amp; DTP

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to graphics and desktop publishing

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

4

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Database

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to databases

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

5

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Spreadsheets

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to spreadsheets

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

6

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Operating Systems

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

File related to operating systems

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

7

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Networking &amp; Comms

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to networking and communications

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

8

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

CAD

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to computer-aided design

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

9

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Programming

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to programming

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

10

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Games

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to games

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

11

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Utilities

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

General utility files

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

12

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Macintosh

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Apple Macintosh files

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

13

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Multimedia

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to multimedia

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

14

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Windows &amp; Utilities

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Various Windows and Windows utility files

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

15

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

News Releases

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Various MCP news releases

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

16

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Que Software

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Software from Que Software

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

17

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

The Internet

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Internet-related topics

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

18

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Sample Chapt./TOCs

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Sample chapters and tables of contents

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

19

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Word Processing

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Files related to word processing

</FONT>

<TR>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

20

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Windows 95

</FONT>

<TD VALIGN=top  BGCOLOR=#80FFFF ><FONT COLOR=#000080>

Items related to Windows 95</FONT>

</TABLE></CENTER><BR>

<A NAME="E69E332"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>The Microsoft Access Forum</B></FONT></CENTER></H4>

<BR>

<P>The Microsoft Access forum (GO MSACCESS) is one of the most active product-support forums on CompuServe. The files that you can download include sample databases and Access libraries created by Microsoft and independent Access developers and consultants, as well as end users of Access applications. You can import much of the code contained in Access modules into Visual C++ database applications using the techniques described in Chapter 18, &quot;Translating Visual Basic and Visual Basic for Applications Code to Visual C++.&quot; You can download current versions of the Access-specific Windows dynamic link libraries (DLLs) that are described in th