Viewed 211 times
We're switching from Microsoft ODBC Driver for Oracle (on Server 2012 R2) to Oracle 12c (12.1) ODBC Driver, in use over old-school COM C++ assemblies.
I have upgraded my system to windows 7 recently. I need to create a odbc connection using microsoft odbc drivers for oracle. But i am not able to find the same in my machine even after oracle client.
We're using msado15.dll for these calls. Our stored procedures that used to return out parameters ie.
no longer return us the expected values. We get 0 back, and we shouldn't.
This all worked fine on Server 2008 with Microsoft ODBC Oracle driver, but the move to Server 2012 R2 necessitated us move to Oracle's ODBC driver. This seems to be our biggest hurdle - hoping someone out there has tackled this previously :)
Did some ODBC tracing as well:
Running the proc in TOAD returns the expected data.
Thanks!
![How to install odbc drivers How to install odbc drivers](https://docs.oracle.com/en/database/oracle/oracle-database/12.2/adfns/img/odbcdrvarch.gif)
John
JohnJohn46611 gold badge44 silver badges1515 bronze badges
Browse other questions tagged c++oraclecomodbcado or ask your own question.
Odbc Drivers Download
From Devart:Oracle Odbc Client 12
Devart ODBC Driver for Oracle provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, Linux and Mac OS X, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with Oracle fast, easy and extremely handy. Key Features: - Direct Connection. Database applications based on our solution get an opportunity to establish connection to Oracle by means of native Oracle client software and in Direct Mode. Direct Mode gives your applications an unrivaled advantage - connection to Oracle databases directly via TCP/IP avoiding Oracle Client. That improves performance of your applications, quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application. - Development Platforms Variety. ODBC driver for Oracle doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, Linux and Mac OS X, both 32-bit and 64-bit. - DB Compatibility. ODBC driver for Oracle supports Oracle servers: 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g. ODBC driver for Oracle supports both x86 and x64 versions of the following Oracle Clients: 12c, 11g, 10g, 9i, 8i, 8.0. Note that support for x64 versions of Oracle Clients is available for 64-bit Windows. - High Performance. All our products are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization. - Support for Oracle Cloud in the Direct Mode. - Showing meta data for the current scheme option. - Improved compatibility with MS Visual Studio, MS Fox Pro, MapInfo, Libre Office, Qlik, Delphi & C++Builder, MS Access.
What do you need to know about free software?
From Devart: Devart ODBC Driver for Oracle provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, Linux and Mac OS X, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with Oracle fast, easy and extremely handy. Key Features: - Direct Connection. Database applications based on our solution get an opportunity to establish connection to Oracle by means of native Oracle client software and in Direct Mode. Direct Mode gives your applications an unrivaled advantage - connection to Oracle databases directly via TCP/IP avoiding Oracle Client. That improves performance of your applications, quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application. - Development Platforms Variety. ODBC driver for Oracle doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, Linux and Mac OS X, both 32-bit and 64-bit. - DB Compatibility. ODBC driver for Oracle supports Oracle servers: 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g. ODBC driver for Oracle supports both x86 and x64 versions of the following Oracle Clients: 12c, 11g, 10g, 9i, 8i, 8.0. Note that support for x64 versions of Oracle Clients is available for 64-bit Windows. - High Performance. All our products are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization. - Support for Oracle Cloud in the Direct Mode. - Showing meta data for the current scheme option. - Improved compatibility with MS Visual Studio, MS Fox Pro, MapInfo, Libre Office, Qlik, Delphi & C++Builder, MS Access.