OLE DB Provider Development with the DataDirect OpenAccess SDK

OpenAccess SDK provides the toolkit and the run-time software components needed to implement an OLE DB provider for your data source within days—easily enable your data source to plug and play with applications written to use OLE DB or ADO. The toolkit is used to build an Interface Provider (IP) to your data source through the implementation of a defined API consisting of 12 functions. Alternatively, you can replace the OpenAccess SDK SQL engine with your own SQL engine by implementing what we call a SQL IP that handles SQL execution.

OpenAccess SDK is suited for making desktop or server based data sources accessible through OLE DB. It provides 99% of the code that is required to open up a database. The other 1% of the code resides between our SQL engine and your database. This is the code you write to take information from the SQL engine and to use it to process rows of data from your database. Whether implementing a local or client/server solution, you write your code with very little concern for the OLE DB interface, SQL, networking, optimization, data types, and many other issues. You worry about taking a request to process data for which we provide you all the information you need to do it optimally. The 1% code you write can be written in C, C++, Java, or a .NET language and this code is the same regardless of whether you want to support ODBC, JDBC, OLE DB, or ADO.NET.

Download | Buy | Data Sheet | Use Cases

Using our SQL Engine
Using our SQL Engine
Click Graphic for a full-sized image

Using your SQL Engine
Using your SQL Engine
Click Graphic for a full-sized image

Product Highlights

  • Simply implement 12 functions to integrate your data source with our SQL engine. You can replace the OpenAccess SDK SQL engine with your own SQL engine by implementing what we call a SQL IP that handles SQL execution.

  • Supports OLE DB 2.0 specifications on Windows.

  • OpenAccess SDK OLE DB implementation offers a high level of compliance to the OLE DB specification. This guarantees compatibility with any application written to the OLE DB specification and with applications that are compatible with SQL Server, Oracle, Sybase, DB2, and other commercial RDBMS.

  • Supports interfacing to data sources using C/C++, Java, or .NET. You can implement a JDBC driver by writing the custom portion in .NET or Java!

  • The finished driver can be completely customized with the driver name, error message pre-fix, error messages, and configuration dialog boxes.

  • All supplied components are fully tested using our extensive test suite. All you have to do is test the custom code you write.

  • Expand your driver offerings to include ODBC, JDBC, and ADO.NET without any additional coding.


Additional Information

Product Overview
Platform Support
Release History
Main Product Page