ADO.NET Provider Development with the DataDirect OpenAccess SDK

OpenAccess SDK provides the toolkit and the run-time software components needed to implement an ADO.NET provider for your data source within days — easily enable your data source to plug and play with applications written to use ADO.NET. 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 ADO.NET. 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 ADO.NET 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. 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.

  • Supports ADO 1.1 specifications on Windows.

  • OpenAccess SDK ADO.NET provider implementation offers a high level of compliance to the ADO.NET specification. This guarantees compatibility with any application written to the ADO.NET 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 an ADO.NET provider by writing the custom portion in C 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 test is the custom code you write.

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


Additional Information

Product Overview
Platform Support
Release History
Main Product Page