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.
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.
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 DomscheitIf 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.
ashleedawgashleedawgNot the answer you're looking for? Browse other questions tagged exceloracleodbc or ask your own question.
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!