ADOSAMP: Implements a Three-Tier Client/Server Application

Click to open or copy the ADOSAMP project files.

This sample implements a three-tier client/server application using ADO, ATL, and Compiler COM support.

The sample demonstrates how you can use Compiler COM support with ADO to create a client/server database application. The application creates a small database of information about motorcycles and their top speeds. The application inserts rows, deletes rows, adds a new column, and searches on top speeds greater than a specified value.

To run the sample

  1. In Windows NT 4.0, open ODBC Data Source Administrator in Control Panel. Using either Microsoft Access or SQLServer, add a (User) DSN with Data Source Name "HotBikes" If you are using Microsoft Access, create a database called Test.

  2. For SQLServer, provide the server name and under Options specify a Database Name, for example, HotBikesDB.

  3. Open ADOSamp.dsw in Visual C++.

  4. In StdAfx.h, edit the path of MsADO10.dll in the #import statement to point to the copy on your machine.

  5. If either OLE DB or ADO has not been installed, install it from the Visual Studio CD. It will most likely be installed in:

    \Program Files\Common Files\System\ADO\MsADO10.dll

  6. Build ADOSamp either as an in-proc (DLL) or local (EXE) server. Registration should be automatic. However, if necessary, run:

    regsvr32 ADOSamp.dll or ADOSamp.exe /RegServer

To build the client

  1. Open RunADO.dsw in Visual C++. Near the top of RunADO.cpp is the line:
    //#define SQLSERVER
    
  2. Uncomment this line if you created a SQLServer data source for this sample. This disables a SQL command that Microsoft Access can understand but SQLServer cannot:

    "ALTER TABLE HotBikes DROP COLUMN ID"

  3. Run RunADO.exe. A table will be created (deleting the existing one) and several rows added, deleted, and updated. A new column is added, populated with data, and, in the case of Microsoft Access, a column is deleted.

    The contents of the table are displayed after each modification.