Query Technology for Database Developers

Dharma ODBCnet

The Dharma ODBCnet component brings ODBC-compliant access to your database in conjunction with the Dharma SQLengine component.

It provides wide compatibility with hundreds of Windows query, reporting, Web and development tools across a variety of platforms. ODBCnet supports an ODBC Version 3.5 driver on Windows clients and provides networking and server-side software that manages interaction with the SQL interface to your database.

Dharma’s extensive ODBC regression tests total over 200,000 lines of code. These tests insure continuing compliance and robustness with the latest standards. Dharma maintains marketing relationships with key tool vendors and tests pre-release versions of their products to insure continued compatibility.

Dharma ODBCnet supports “Extended SQL Grammar”, the broadest level of the ODBC standard. This includes nested queries, recursive views, case expressions, outer joins, positioned updates, union, intersect and minus set operations,ODBC-compatible scalar functions, extended data types, and procedure calls. Extended SQL provides high-end decision-support functionality with the power to answer complex business questions.

Dharma ODBCnet is tailored for high performance production environments, including online transaction processing and decision support applications. Specialized stored procedures and client-side caching give you efficient metadata access. Optimized client/server interactions provide efficient online transaction processing. Extensive client-side buffering reduces network traffic resulting in fast ad-hoc queries. Dharma’s performance tests show that ODBCnet gives equal or superior performance compared to other leading vendors.

Review the ODBCnet Fact Sheet