Creating an OLE DB Data Provider

David Utz

Rate me:

3.45/5 (13 votes)

12 Jan 20029 min read

128.3K

3.4K

This article shows how to create an OLE DB Data Provider that wraps both a C struct and C++ class containing data that is to be made accessible by a SQL query.

sensorexample.zip
- SensorInterf
  - _recordset.cpp
  - _recordset.h
  - datacombo.cpp
  - datacombo.h
  - DlgProxy.cpp
  - DlgProxy.h
  - field.cpp
  - field.h
  - fields.cpp
  - fields.h
  - font.cpp
  - font.h
  - oleobject.cpp
  - oleobject.h
  - oleobjects.cpp
  - oleobjects.h
  - picture.cpp
  - picture.h
  - properties.cpp
  - properties.h
  - property.cpp
  - property.h
  - res
    - SensorInterf.ico
    - SensorInterf.rc2
  - resource.h
  - richtext.cpp
  - richtext.h
  - SensorInterf.cpp
  - SensorInterf.dsp
  - SensorInterf.dsw
  - SensorInterf.h
  - SensorInterf.odl
  - SensorInterf.plg
  - SensorInterf.rc
  - SensorInterf.reg
  - SensorInterfDlg.cpp
  - SensorInterfDlg.h
  - StdAfx.cpp
  - StdAfx.h
- SensorTest
  - Embsql.h
  - IColumnsRowsetImpl.h
  - ICommandWithParametersImpl.h
  - IMyRowsetUpdate.h
  - IMyRowsetUpdateImpl.h
  - IRowsetChangeImpl.h
  - IRowsetNotifySourceImpl.h
  - MyData.cpp
  - MyData.h
  - MySensor.rgs
  - MySensorCmd.cpp
  - MySensorCmd.h
  - MySensorDS.h
  - MySensorRS.cpp
  - MySensorRS.h
  - MySensorSess.cpp
  - MySensorSess.h
  - resource.h
  - SensorTest.cpp
  - SensorTest.def
  - SensorTest.dsp
  - SensorTest.dsw
  - SensorTest.h
  - SensorTest.idl
  - SensorTest.plg
  - SensorTest.rc
  - SensorTest.tlb
  - SensorTest_i.c
  - SqlCollection.cpp
  - SqlColumn.cpp
  - SqlParser.cpp
  - SqlTable.cpp
  - StdAfx.cpp
  - StdAfx.h

REGEDIT
; This .REG file may be used by your SETUP program.
;   If a SETUP program is not available, the entries below will be
;   registered in your InitInstance automatically with a call to
;   CWinApp::RegisterShellFileTypes and COleObjectFactory::UpdateRegistryAll.


HKEY_CLASSES_ROOT\SensorInterf.Application = SensorInterf Application
HKEY_CLASSES_ROOT\SensorInterf.Application\CLSID = {166F9F2E-EA77-4CD9-923A-E97A3B2F8131}

HKEY_CLASSES_ROOT\CLSID\{166F9F2E-EA77-4CD9-923A-E97A3B2F8131} = SensorInterf Application
HKEY_CLASSES_ROOT\CLSID\{166F9F2E-EA77-4CD9-923A-E97A3B2F8131}\ProgId = SensorInterf.Application
HKEY_CLASSES_ROOT\CLSID\{166F9F2E-EA77-4CD9-923A-E97A3B2F8131}\LocalServer32 = SENSORINTERF.EXE

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By

David Utz

Web Developer

United States

David Utz
Senior Software Engineer
Analytical Graphics, Inc.
40 General Warren Blvd.
Malvern, PA 19355
dutz@stk.com

Creating an OLE DB Data Provider

License

Comments and Discussions