Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 401 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Installing ODBC driver via Instant Client
I downloaded the instant client instantclient-basic-windows.x64-12.2.0.1.0.zip from Instant Client for Microsoft Windows (x64) 64-bit. The installation instruction ODBC Instant Client Release Notes mentions to unzip (I unzipped in instantclient_12_1 folder) and run odbc_install.exe for Windows Installing Oracle Instant Client ODBC. However there is no odbc_install.exe file under instantclient_12_1 folder. I followed another instruction to set PATH env variable to include path to this instantclient_12_1 folder, but I dont see Oracle ODBC driver in the ODBC Data Source Administrator to configure a data source.
How do you install this ODBC driver and make it available in Windows ODBC Administrator? I am trying to connect to an Oracle db from Crystal Reports tool.
Thanks.
Best Answer
-
Hi there,
You also need to download instantclient-odbc-windows.x64-12.2.0.1.0-2.zip from the same web page. And then unzip instantclient-basic-windows.x64-12.2.0.1.0.zip and instantclient-odbc-windows.x64-12.2.0.1.0-2.zip into the same directory (eg intantclient_12_2). Then follow the instruction in ODBC_IC_Readme_Win.html which you can find under directory intantclient_12_2.
Hope it helps.
Answers
-
Hi there,
You also need to download instantclient-odbc-windows.x64-12.2.0.1.0-2.zip from the same web page. And then unzip instantclient-basic-windows.x64-12.2.0.1.0.zip and instantclient-odbc-windows.x64-12.2.0.1.0-2.zip into the same directory (eg intantclient_12_2). Then follow the instruction in ODBC_IC_Readme_Win.html which you can find under directory intantclient_12_2.
Hope it helps.
-
Very odd that Instant Client for Microsoft Windows (x64) 64-bit shows one basic OR one basic lite file and your response refers to a hidden file to obtain the elusive odbc_install.exe.
And the articles for installing on windows are cryptic and arcane requiring directories to be created, path variables, windows registry settings etc. I do miss the old days where everything you need was in one place and installation was straight forward i.e. setup.exe with wizards without requiring convoluted multiple external resources to determine how to utilize a driver.
The sad thing is that on that page, there is no feedback component to ask customers if there was a problem procuring resources, installation etc resulting in wasted time for those unfamiliar with the new process.
Any ways grateful for a link and to begin the fourth attempt in trying to install an Oracle ODBC driver to use with Excel for my client. Sigh
-
Hi Ken,
Sorry to hear that you had troubles to install Oracle ODBC driver. The installing instruction has been updated to make it clearer that two packages are required. Please see: ODBC Instant Client Release Notes
Thanks for your valuable feedback.
-
Hi, I'm Covi.
I'm in the process of trying to install Oracle ODBC x64-12.2.0.1.0 and X32. driver onto Windows Server 2012. This process is the most unsuccessful process I've ever encountered installing windows server bits and has consumed much of my time.
Ken_553995 is right on,
Oracle I don't think you could have made this anymore difficult!
How about a simple ODBC installer that does everything that's needed? No manual anything other than click install.
Thanks - Covi
-
HI
You can find installation instruction under
Instant Client for Microsoft Windows (x64) 64-bit
Once you edthe 64 bit Client, then you need to start the ODBC Administrator from C:\Windows\System32\odbcad32.exe for 64 bit Oracle ODBC driver.
create DSN and test
Thanks
Thiaygu