1.1.Overview
The OpenLink Express Edition driver is a client-only installation and goes some way to ensure the job for developers, administrators and end-users is simplified. Part of this process means installing the software in one location as opposed to numerous locations. By discarding the server-side setup, there is no server-side administration so the user has only a single entry-point for installation and administration. In the majority of cases, knowing the database by name is all that is required.
To the developer writing an application, there is no requirement to know on which server it resides: you can write your application for any environment, regardless of where it will end. There are also performance benefits gained by employing this single solution, which in some cases exceeds that provided by the database vendor's drivers. Being able to integrate your solution simply into your organization with its plethora of internal and disparate systems means your RoI increases significantly.
1.1.1.Driver Architecture
These drivers are built by implementing the ODBC data-access interface specifications directly connecting to the database. There are no limiting factors as with traditional Single-Tier solutions.
The Express Edition drivers are Type-B- or -C-based remote procedure calls (RPC) interface to the wire-protocol of the underlying database. This is a client-only interface that communicates directly with the remote database server. These interfaces typically are unavailable to third-party developers. To date the Open Source projects such as FreeTDS, MySQL, PostgreSQL and Interbase are the only publicly accessible and freely available versions of such interfaces.
The ODBC Express Edition drivers offer developers an opportunity to develop generic solutions across platforms without prior knowledge of the operating system hosting the Database server.
1.1.2.System Requirements
Software Requirements
You must have the following software to use OpenLink Express Edition ODBC Drivers:
-
One or more ODBC-compliant application(s).
-
A supported database server.
-
The OpenLink Express Edition ODBC Driver for the target database server
-
A valid license file for each required OpenLink Express Edition ODBC Driver.
Hardware Requirements
You must have the following hardware to use OpenLink Single-Tier Drivers for ODBC:
-
A TCP/IP network connection to the database server from the client machine the Express Edition driver is installed on.
-
An ODBC Application Host running an operating system that is supported by OpenLink Express Edition ODBC Drivers. The currently supported operating systems are Mac OS X 10.3 (PPC), Mac OS X 10.4 (PPC & Intel). Please check the OpenLink website http://www.openlinksw.com/ to verify availability of support for an operating system.
The ODBC client applications you want to use may have their own hardware or software requirements, which must also be satisfied.
1.1.3. Installation and Configuration Guide
This section provides a step-by-step guide for the installation and configuration of the OpenLink Express Edition drivers.