Skip to main content

Demo - Using ActiveX Data Objects (ADO) to access SQL databases

  • February 15, 2013
  • 0 replies
  • 0 views

Problem:

This demo shows how you can use ActiveX Data Objects (ADO) from a Net Express application.

For more information on the Methods/Properties and events being used here please see the Microsoft Platform SDK documentation:-

http://msdn.microsoft.com/library

Resolution:

BUILD W/RELEASE:     Net Express V3.1 and MDAC 2.5.

In order to use this demo you need to have the Microsoft Data Access componants (MDAC) installed. This is available for download at http://www.microsoft.com/data/

This demo has been written and tested using Net Express V3.1

SOURCE FILES:

==========

Program Files      Description

----------------     -----------------------------------------------------------

ADOData            Main ADO Sample Code A

DOEvents           ADO COM Event handler

Copy Files:

----------------     -----------------------------------------------------------

ADOTypeLib      Generated by Net Express Type Library Assistant. It contains constants

                          and type definitions of various parameters and method calls.

OPERATION:

========

To run the demo compile it and run as normal within the Net Express IDE. Uses the sample Access datasource "NetExpress Sample1" to retrieve and display the discriptor text from the course_descriptor table.

NOTE:

====

Needs Microsoft Data Access componants installs (MDAC).

==========================================================

Keywords: Example, sample, demo, demonstration, SQL, adosql.zip

demo.ex

demo.ne

Attachments:

adosql.zip

Old KB# 4348