Forum Stats

  • 3,814,894 Users
  • 2,258,926 Discussions
  • 7,892,883 Comments

Discussions

Hi I am trying to connect to oracle database using excel but I am getting error as Oracle Client and

3206607
3206607 Member Posts: 1
edited Mar 28, 2016 2:00AM in ODBC

Hi I am trying to connect to oracle database using excel but I am getting error as Oracle Client and networking components are supplied by oracle corporation and are aprt of Oracle version 7.3. or later client software installation. Provider is unable to function untill these components are installed. Please help.

Answers

  • Sdhamoth-Oracle
    Sdhamoth-Oracle Member Posts: 184 Employee
    edited Mar 28, 2016 2:00AM

    You need to have Oracle Client or Instant Client installed in your Windows environment to access Oracle database via Excel.

    Also make sure you Oracle environment variables are set in the environment either through command prompt or registry. In case if you don't have Oracle environment variables setting is not in your registry, set them in command prompt and invoke Excel from that command prompt. This would allow you connect to Oracle database via Excel without any error.

    Refer following notes for more details about Instant client and ODBC driver installation:

    ODBC Instant Client Release Notes

    Oracle ODBC Drivers

This discussion has been closed.