Forum Stats

  • 3,783,500 Users
  • 2,254,786 Discussions
  • 7,880,439 Comments

Discussions

Installing ODBC driver via Instant Client

2d2a22ee-1912-448d-b5be-9f5151a990e9
edited Jun 9, 2018 4:19AM in ODBC

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.

dc579d6e-459f-41ec-9b12-1695f02ca943user6163812

Best Answer

Answers

  • ytf-Oracle
    ytf-Oracle Member Posts: 5
    edited May 22, 2018 3:17AM Accepted 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.

  • Ken_553995
    Ken_553995 Member Posts: 9 Blue Ribbon
    edited May 29, 2018 1:26PM

    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

    dc579d6e-459f-41ec-9b12-1695f02ca943
  • ytf-Oracle
    ytf-Oracle Member Posts: 5
    edited Jun 3, 2018 8:45PM

    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.

  • dc579d6e-459f-41ec-9b12-1695f02ca943
    edited Jun 8, 2018 5:59PM

    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

    user6163812
  • Thiyagu - Oracle
    Thiyagu - Oracle Member Posts: 30
    edited Jun 9, 2018 4:19AM

    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

This discussion has been closed.