Creating your own OLEDB Provider

1
Creating your own OLEDB Provider

• Phil Denoncourt III
• Director of Technology
• Luna Systems Corporation

2
About OLEDB Providers
Data
OLEDB
Application
Consumer (ADO)
Provider
3
Creating your own providers

• Why?
• To get at non-traditional data sources easily
• Sourcesafe
• Quicken
• Word Documents
• Custom Applications
• To enforce business rules
• On updates or read to specific sources, log
  transaction

4
Creating your own providers

• How?
• In VB create a new project
• Reference OLE Simple Toolkit Library
• Add two classes
• In one class implement OLEDBSimpleProvider
• Set the DatasourceBehavior property to
  vbDatasource on the other
• Create a registry file to install the driver

5
The two classes
Data Source
Provider

• Gets Created for each connection
• Returns reference to provider object

• Where data retrieval code exists
• Methods for Read,Update, Delete, and Insert
• Can be implemented asynchronously