Re: Where can I download an odbc driver for Windows 7/oracle 10g? Sdhamoth-Oracle Oct 26, 2017 3:37 PM ( in response to 3485059 ) If your database is 10.2, then you can use Instant Client version 12.1.0.2. 64-bit ODAC for Windows consists of Oracle client side drivers, including ODP.NET, ODBC, OLE DB, and Oracle Services for MTS. Jan 19, 2017 The Microsoft® ODBC Driver for Oracle allows you to connect your ODBC-compliant application to an Oracle database. The ODBC Driver for Oracle conforms to the Open Database Connectivity (ODBC) specification described in the ODBC Programmer's Reference.It allows access to PL/SQL packages, XA/DTC integration, and Oracle access from within Internet Information Services (IIS). 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. Setting up an Oracle ODBC Driver and Data Source requires more steps than the Microsoft SQL Server database setup. This article explains the steps including tnsnames.ora configuration. Connecting to an Oracle database via and ODBC driver requires the following steps.
9.1 Obtaining a JDBC DriverIt is recommended that you obtain a commercial JDBC driver from a vendorsuch as your database vendor or your database middleware vendor. Check the list of drivers currently available.
The JDBC-ODBC Bridge driver is recommended only for experimental use orwhen no other alternative is available.
9.2 JDBC-ODBC BridgeIf possible, use a Pure Java JDBC driver instead of the Bridge and an ODBC driver. This completely eliminates the client configuration required by ODBC. It also eliminates the potential that the Java VM could be corrupted by an error in the native code brought in by the Bridge (that is, the Bridge native library, the ODBC driver manager library, the ODBC driver library, and the database client library).
The JDBC-ODBC Bridge driver is recommended for use in prototyping effortsand for cases where no other JDBC technology-based driver exists. If acommercial, all-Java JDBC driver is available, we recommend that it beused instead of the Bridge.
9.2.1 What Is the JDBC-ODBC Bridge?The JDBC-ODBC Bridge is a JDBC driver that implements JDBC operations by translating them into ODBC operations. To ODBC it appears as a normal application program. The Bridge implements JDBC for any database for which an ODBC driver is available. The Bridge is implemented as thesun.jdbc.odbc Java package and contains a native library used to access ODBC. The Bridge is a joint development of Merant and Java Software.
9.2.2 ODBC Compatibility and ODBC Versions Supported
On Solaris, the JDBC 2.0 bridge must be used with an ODBC 3.x driver manager. The bridge supports both ODBC 2.x and ODBC 3.x drivers, but has been testedwith only ODBC 3.x drivers.
On NT, the JDBC 2.0 bridge supports the ODBC 2.x and ODBC 3.x driver manager anddrivers. The JDBC 2.0 bridge has been tested only with an ODBC 3.x drivermanager and with both ODBC 2.x and 3.x drivers.
Merant recommends that the JDBC 2.0 bridge be used with version 3.5 orhigher of Merant's DataDirect ODBC drivers.
9.2.3 The Bridge ImplementationThe Bridge is implemented in Java and uses Java native methods to call ODBC.9.2.4 InstallationThe Bridge is installed automatically with the Java 2 SDK, Standard Edition,as packagesun.jdbc.odbc . See your ODBC driver vendor for information on installing and configuring ODBC. No special configuration is required for the Bridge. See your database vendor for client installation and configuration information. On Solaris, some ODBC driver managers name their libs libodbcinst.so and libodbc.so . The Bridge expects these libraries to be named libodbcinst.so.1 and libodbc.so.1 , so symbolic links for these names must be created.
9.3 Using the BridgeThe Bridge is used by opening a JDBC connection using a URL with theodbc subprotocol. See below for URL examples. Before a connection can be established, the bridge driver class, sun.jdbc.odbc.JdbcOdbcDriver , must either be added to the java.lang.System property named jdbc.drivers , or it must be explicitly loaded using the Java class loader. Explicit loading is done with the following line of code:
When loaded, the ODBC driver (like all good JDBC drivers) creates an instance of itself and registers this with the JDBC driver manager.
9.3.1 Using the Bridge from an AppletJDBC used with a Pure Java JDBC driver works well with applets. The Bridge driver does not work well with applets.9.3.2 Most Browsers Do Not Support the BridgeSince the Bridge is an optional component of the Java 2 SDK, Standard Edition,it may not be provided by a browser. Even if it is provided, only trusted applets (those allowed to write to files) will be able to use the Bridge. This is required in order to preserve the security of the applet sandbox. Finally, even if the applet is trusted, ODBC and the DBMS client library must be configured on each client.9.3.3 Tested ConfigurationsFrom Solaris, we have used the Bridge to access Oracle 8.1.5 using version3.5 of Merant's ODBC drivers.From NT, we have used the Bridge to access SQL Server 6.x using the latestODBC driver from Microsoft.9.3.4 ODBC Drivers Known to Work with the BridgeODBC drivers are available for Oracle, Sybase, Informix, Microsoft SQLServer, and Ingres. The MERANT ODBC driver suite should be completely compatible with the JDBC-ODBC Bridge. To evaluate or purchase MERANT ODBC drivers, please contact MERANT DataDirect Sales at1-800-547-4000 Option 2 or via the World Wide Web athttp:www.merant.com . The MS SQL Server driver has also been used successfully on NT. Many other ODBC drivers will likely work.
9.3.5 What Is the JDBC URL Supported by the Bridge?The Bridge driver uses theodbc
Oracle Odbc Driver Download For Windows 64 Bitsubprotocol. URLs for this subprotocol are of the form:
For example:
9.3.6 DebuggingThe Bridge provides extensive tracing whenDriverManager tracing is enabled. The following line of code enables tracing and sends it to standard out:
9.4 New JDBC 2.0 API Features Supported by the BridgeOracle Odbc Driver Download Windows
The JDBC-ODBC Bridge driver in this release supports the following new featuresin the JDBC 2.0 API:
The current release of the Bridge supports multi-threaded ODBC driversand contains numerous bug fixes. [Top][Prev][Next][email protected] or [email protected]Copyright © 1996 - 1999 Sun Microsystems, Inc. All rights reserved.
Is getting to your data slowing the growth of your business? Need an Oracle® ODBC driver that is best in class?
Install Oracle Odbc Driver
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, 12c and 18c
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+, 12c Release 1+ and 18c.
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.
Delete profile list registry windows 10. 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:
Demos
Installing the Easysoft Limited Oracle® ODBC Driver on Linux
)
![]()
Installing the Easysoft Limited Oracle® ODBC Driver on Linux in less than 60 seconds
Diagrams
Easysoft ODBC-Oracle Driver:
Easysoft ODBC-Oracle WP Driver:
Oracle Odbc Drivers Windows 7Platforms
The Easysoft ODBC-Oracle Driver (OCI version) is currently available on these platforms:
HP Integrity ReadyOracle Odbc Driver Download 11g
The Easysoft ODBC-Oracle Driver for HP-UX and Linux Itanium was built and tested on HP Integrity Servers, which offer maximum hardware potential, reduced costs and unsurpassable performance.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |