Oracle ODBC driver comparison
This article compares the OCI version of the Easysoft Oracle ODBC driver with Oracle's ODBC driver. It discusses the strengths both these OCI client-based products share and the advantages of using the Easysoft driver. At a glance:
| Oracle driver | Easysoft driver |
|---|---|
| Uses the client libraries, giving your applications access to the latest Oracle performance, scalability and security features. | Uses the client libraries, giving your applications access to the latest Oracle performance, scalability and security features. |
| Microsoft Windows only, apart from the ODBC driver for Oracle 10.2 and later. | Available on Linux, UNIX (including Solaris, HP-UX, and AIX) and Windows. |
| Compatible with unixODBC. | Compatible with unixODBC, a project currently led by Easysoft developer Nick Gorham that we have many years of experience in supporting. |
| Separate driver for each Oracle version. | One driver supports multiple Oracle versions. |
| Compatible with a particular version of the Oracle client. To upgrade the client you also need to upgrade the ODBC driver. | Compatible with multiple versions of the Oracle client. You can easily upgrade the Oracle client without changing your ODBC driver. |
Using the Easysoft Oracle ODBC driver instead of the Oracle ODBC driver still means that you can take advantage of Oracle's expertise in accessing their database. Your applications will still use the Oracle client software. It also means that you can take advantage of our expertise in developing ODBC drivers.
Oracle client libraries
The Easysoft Oracle ODBC driver like Oracle's ODBC driver uses the Oracle client libraries to access Oracle. Easysoft believe that the right way to access Oracle is to use their database interface. When developing the Oracle driver, we chose to use this method — the one that Oracle recommend — so that we could concentrate on our driver's functionality and you could benefit from the advantages that the client provides.
Latest functionality
The client libraries support the entire Oracle database feature set. The newest performance, scalability, and security features appear first in the Oracle client libraries. The functionality provided by the client libraries lets you build high performance, secure, scalable, and fault-tolerant applications.
Easysoft ensure that the Easysoft Oracle ODBC driver supports the latest version of the ODBC API. Because the Easysoft Oracle ODBC driver uses the client libraries and Easysoft track ODBC API developments, your applications can access the latest database features with the most current version of the ODBC API.
Improved performance and scalability
The Oracle client libraries improve application performance and scalability through efficient usage of system memory and network connectivity. Using the client libraries, an application can service increasing numbers of users and requests without additional hardware investments.
Reliability
The client libraries are the backbone for the Oracle database. Since the libraries are the standard way to access Oracle, they are a very well tested interface.
Easysoft test the Easysoft Oracle ODBC driver with many different applications on many different platforms to ensure it is reliable and compatible with your application, programming language, and development environment on Linux, UNIX, and Windows.
unixODBC support
Both the non-Windows Oracle ODBC driver and the Easysoft Oracle ODBC driver are compatible with unixODBC, the open-source Driver Manager. The Easysoft Oracle ODBC driver distribution contains unixODBC and can install and configure itself into unixODBC making it immediately available to all your ODBC applications.
The unixODBC project is currently led by Easysoft developer Nick Gorham. This means that there is a great deal of experience at Easysoft of unixODBC in general and of supporting the Easysoft Oracle ODBC driver running under unixODBC. It also means that if you find a problem in unixODBC, it is much easier for us to facilitate a fix.
One driver supports multiple Oracle versions
Usually, the ODBC driver shipped with a particular version of the Oracle client software is valid for that version of the client. This means that there is a separate version of the ODBC driver for each version of the Oracle database. With the Easysoft Oracle ODBC driver, Oracle 8.1.7 through to the latest Oracle release are all supported in a single product. No upgrades are required. You can also use our driver with multiple versions of Oracle at the same time.
