Oracle 12 Odbc Drivers

The TAR archive contains the latest 12.1.0.1 JDBC Thin driver (ojdbc7.jar and ojdbc6.jar), Universal Connection Pool (ucp.jar), other companion jars, and README that has more information about the contents of the tar file. 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.

Active1 year, 3 months ago
Odbc

Need your expert suggestion on the below please.

In my office we don't have a specific package for Oracle ODBC driver, what we have is either oracle 11g or other software with which the driver is included. Now we want to create a separate package for the driver itself. Once the drive is installed we would connect our excel or any office application to the DB.

Because we cant download and run the exe files directly I need to raise a service request with our software packaging team and I need to provide the link from where they can get the package. Then they can download from there and will create a installable package for the team.

I looked through google and came up with below link.

I am providing the OS details below, could you guys please confirm if its the right package I am referring to or I need something else.

System Details

Windows Edition: Windows 7 Enterprise (SP1)System Type: 64 bit

We need to connect to an Oracle database.

Thank you for your guidance in advance.

Anurag PattanayakAnurag Pattanayak

2 Answers

I think you must download from Instant Client Downloads for Microsoft Windows 32-bit

Package instantclient-odbc-nt-12.2.0.1.0-2.zip

I assume your Excel is 32-bit, thus you must install also the 32-bit version of Oracle. Otherwise use Instant Client Downloads for Microsoft Windows (x64) 64-bit

The 64-bit Oracle ODBC does not work with 32-bit Excel! (or vice versa)

Oracle 12c Odbc Driver Connection String

Wernfried DomscheitWernfried Domscheit
27.4k4 gold badges35 silver badges63 bronze badges

If I understand correctly you just want to confirm the download for an Oracle ODBC Driver for 64-bit Windows. This isn't a programming question but the short answer is, yes that looks correct.

In my experience ODBC installation is rarely straightforward, so worst-case, you can uninstall the driver and try a different one. For example, this link claims to be an 'Instant Client' including ODBC support.

With SQL Server/ODBC on Windows 7 64 bit, I had a lot of problems before I tried the 32-bit version, which worked fine.

Any further questions about setting this up might be better suited to SuperUser.

ashleedawgashleedawg
13.8k4 gold badges29 silver badges62 bronze badges

Not the answer you're looking for? Browse other questions tagged exceloracleodbc or ask your own question.

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.

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:

Oracle Odbc Client 12

Running the proc in TOAD returns the expected data.

Oracle 12c Odbc Driver Download 64 Bit

Thanks!

John
JohnJohn
4661 gold badge4 silver badges15 bronze badges

Browse other questions tagged c++oraclecomodbcado or ask your own question.