Daffodil DB Open Database Connectivity (ODBC) Driver is a high-performance 32 Bit ODBC Driver that provides transparent access to remote databases from any ODBC-compliant application. It processes ODBC function calls, submits Structured Query Language (SQL) requests to specific data source, and returns results to applications. It is based on the Call-Level Interface specifications from X/Open and ISO/IEC for database APIs and uses SQL as its language for accessing databases.

Daffodil DB is a powerful and flexible SQL Relational Database Management System (RDBMS) that supports an interactive Structured Query Language (SQL), a Microsoft Open Database Connectivity (ODBC) compatible interface.

Daffodil DB ODBC Driver allows you to connect to a Daffodil DB database server using the ODBC database API on Microsoft Windows Platforms.

The production-ready version of Daffodil DB ODBC fully conform to the ODBC 3.0 specification for Core API and Level 1 API, and supports most of the Level 2 function calls.

Working Model

In the ODBC Driver working model - Application communicates with the Driver Manager, which is a library that manages communication between application and driver or drivers or with the Driver directly using the standard ODBC calls irrespective of where data is stored, how it is stored or even how the system is configured to access the data. Data Source Name (DSN) is the only important thing to be known. Following tasks are perfortmed by the application:
 Selecting the (Daffodil DB) server and connecting to it.
 Submitting an SQL statement for execution.
 Retrieving results.
 Processing errors.
 Committing or rolling back the transaction enclosing the SQL statement.
 Disconnecting from the Daffodil DB server.
The Driver manager uses ODBC.INI, which is a configuration file that stores information on driver and databases required for connecting to the server, to determine which driver to be loaded using the Data Source Name. Driver uses this to read connection parameters on the basis of specified DSN.

Features of ODBC Driver
 Blistering Performance.
 ODBC 3.x Compliance.
 ODBC Core, Level 1, Level 2, and Extensions support.
 Client based Scrollable Cursor Support.
 Client Operating Systems Supported:
Windows 98/NT/ME/2000/XP.
 Full support for stored procedures execution.
 Support for all types of cursors.
 Support for all types of locks except BatchOptimistic.
 Support for all ResultSet functions.


Daffodil DB ODBC Driver comes as an add-on with the commercial copy of Daffodil DB. For further information on Daffodil DB log on to www.daffodildb.com.

All rights reserved. Daffodil DB™ is a registered trademark of Daffodil Software Limited. Java™ is a registered trademark of Sun Microsystems, Inc. All other brand and product names are trademarks of their respective companies.