Installing Oracle Driver For Odbc
Is getting to your data slowing the growth of your business? Need an Oracle ODBC driver that is best in class? Our super fast Oracle ODBC driver simply allows any ODBC-enabled application to access Oracle databases; as you would expect from Easysoft, our driver connects from Windows (both 32-bit and 64-bit versions), Linux and Unix, and we support all the major versions of Oracle (including the latest). Take a look at the technical description below for more information. As you would imagine from a company that prides itself on its "customer first" focus, the driver is easy to install and our support team is here to help you with any difficulties or questions that you might have. We are rightly proud of our support team, and any problems you might have are usually resolved within 24 hours; free drivers cannot offer you such a support service. As with all of our drivers, this Oracle ODBC driver offers ODBC 3.5 support. Easysoft is an Oracle Gold Partner. Oracle ODBC Driver for 8, 9i, 10g, XE, 11g and 12c The Easysoft ODBC-Oracle Driver lets ODBC-enabled applications access Oracle databases from Linux, Unix and Windows 32 bit and 64 bit platforms. It supports Oracle 8.1.7+, 9i.x, 10g Release 1+, Oracle Database 10g Express Edition (Oracle Database XE), 11g Release 1+ and 12c Release 1+. There are two versions of the Easysoft ODBC-Oracle Driver: an Oracle Call Interface (OCI) version and a Wire Protocol (WP) version. The Easysoft ODBC-Oracle Driver (OCI version) uses Oracle client software to access the Oracle database. This is Oracle’s only supported method for accessing the Oracle database. The driver is compatible with the standard Oracle Database Client or the Instant Client. The Oracle client software provides the most comprehensive access to Oracle database functionality. For example, the Oracle Advanced Security option is an Oracle client or server add-on that combines network encryption, database encryption and strong authentication to protect sensitive data stored in Oracle databases. Applications that access Oracle by using the Easysoft ODBC-Oracle Driver can take advantage of the Oracle Advanced Security option. This is not true of some of the Easysoft ODBC-Oracle Driver’s competitor’s products. Drivers that do not use the Oracle client software do not support features offered by the Oracle client software. Even if you do not currently need the additional functionality provided by a client add-on, using the Easysoft ODBC-Oracle Driver gives you the option to add it later, should your requirements change. The Easysoft ODBC-Oracle Driver (WP version), which does not use Oracle client software, provides direct access to Oracle, for use in solutions where minimising the client footprint is a requirement. The Easysoft ODBC-Oracle Driver can be installed either on the Oracle database server or a remote client machine. The Easysoft ODBC-Oracle Driver: Conforms to the ODBC 3.5 specification. Works with ODBC 2.0, 2.5, 3.0 and 3.5 applications. Supported programming interfaces include Perl DBI and DBD::ODBC, Python mxODBC and pyodbc and PHP. Supported applications include ApplixWare, OpenOffice.org, StarOffice, Microsoft Access and Microsoft Excel. Is available in both 32 bit and 64 bit Oracle ODBC Driver versions. Supports Oracle Native SQL syntax. Works with the Oracle Database Client and the Instant Client. Uses Oracle Net or Net8 and client libraries, ensuring client/server compatibility. Uses Oracle client configuration settings, simplifying configuration and data source administration. Allows access to Oracle Real Application Clusters (RAC). An Oracle RAC database spans multiple low-cost servers yet appears to an application as a single, unified database system. RAC combines the processing power of these servers to provide system redundancy, scalability, and high availability. Provides full support for all Oracle data types, including LONG and large objects (LOBs). Supports transactions. Can take part in distributed XA transactions. Is compatible with Oracle Advanced Security features including data integrity protection, data encryption and strong authentication using third party services such as Kerberos and Remote Authentication Dial-In User Service (RADIUS). Is compatible with and includes unixODBC, the open source ODBC Driver Manager for non-Windows platforms. The Easysoft ODBC-Oracle Driver installation can automatically install the driver into unixODBC, making the ODBC-Oracle Driver immediately available to your ODBC applications. The unixODBC project is currently led by Easysoft developer Nick Gorham and we have many years of experience in supporting and testing our drivers with unixODBC. Is thread-safe and therefore safe to use behind multi-threaded applications. Lets you configure ODBC calls to reduce metadata and increase performance. Lets you generate diagnostic trace logs that enable you to monitor the ODBC calls an application makes. This helps you diagnose problems.
This chapter contains the following sections: Topics: 21.1 About Oracle ODBC Driver What is ODBC? Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources. The application's source code does not have to be recompiled for each data source. A database driver links the application to a specific data source. A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. Therefore, the application can access any data source for which a database driver exists. The ODBC interface defines the following: A library of ODBC function calls that allows an application to connect to a data source, execute structured query language (SQL) statements, and retrieve results. SQL syntax based on the SQL-99 specification. A standard set of error codes. A standard way to connect to and log in to a data source. A standard representation for data types. Figure 21-1 shows the components of the ODBC model. The model begins with an ODBC application making a call to the Driver Manager through the ODBC application program interface (API). The Driver Manager can be either the Microsoft Driver Manager or the unixODBC Driver Manager. Still using the ODBC API, the Driver Manager makes a call to the ODBC Driver. The ODBC Driver accesses the database over a network communications link using the database API. Figure 21-1 shows an ODBC application accessing three separate databases. Figure 21-1 Components of the ODBC Model
1 Reviewing Information About This Guide. This guide describes how to install Oracle Database by using the default installation options. Tasks Described in This Guide.
JDBC Tutorials - Herong s Tutorial Examples JDBC-ODBC Bridge Driver - MS Access. This chapter provides tutorial notes on using the JDBC-ODBC Bridge driver.
- My team are trying to migrate from ORACLE 10g to 11g. These are our system specs: Our current production server: ORACLE 10.2g ORACLE Application Express 3.0.
- 21.2.1.1 What is the Oracle ODBC Driver. The Oracle ODBC Driver enables ODBC applications on Microsoft Windows, as well as UNIX platforms like Linux, Solaris, and.
- Oracle ODBC driver for Oracle 8, 9i, 10g, XE, 11g and 12c. Available on Linux, Unix and Windows platforms.
- ODBC Instant Client 1 ODBC Instant Client ODBC Instant Client offers all the.
