Forum Stats

  • 3,816,065 Users
  • 2,259,136 Discussions
  • 7,893,382 Comments

Discussions

Setting up an Oracle ODBC Driver and Data Source (Windows 7 and Oracle 10/11)

user13313538
user13313538 Member Posts: 1 Blue Ribbon
edited Jul 28, 2015 1:14PM in ODBC

Hello everyone,

One of our QA testers recently suffered a workstation failure. We installed a brand new workstation with Windows 7.

This employee makes heavy use of MS Excel which needs to connect to several Oracle 10 and 11 databases to pull data to fill out in his reports.

We followed this document to install an ODBC connector:

https://tensix.com/2012/06/setting-up-an-oracle-odbc-driver-and-data-source/

We successfully installed the Oracle driver. But the problem is that Oracle driver is not visible in Microsoft ODBC Data Source Administator.

Can anyone shed some light on this?

Answers

  • Unknown
    edited Jul 28, 2015 12:32PM
    We followed this document to install an ODBC connector: 
    
    https://tensix.com/2012/06/setting-up-an-oracle-odbc-driver-and-data-source/
    
    We successfully installed the Oracle driver. But the problem is that Oracle driver is not visible in Microsoft ODBC Data Source Administator.
    

    Post proof that you 'successfully installed' the Oracle driver. The fact that the driver isn't visible suggests otherwise.

    Reread that article and you will see that it provides EACH AND EVERY step that needs to be done.

    Reread your original post and you will see that you provided NONE OF THE STEPS that you did.

    See the difference? You need to SHOW US (not tell us)

    1. WHAT you do

    2. HOW you do it

    3. WHAT results you get

  • Unknown
    edited Jul 28, 2015 12:38PM

    >Can anyone shed some light on this?

    You have either error of commission or error of omission, but we can't know for sure since we don't know what you actually did do.

    BTW, this is really off topic, since problem & solution have nothing directly to do with the database.

    root cause & fix are strictly at the OS/Windows level

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    edited Jul 28, 2015 12:43PM
    user13313538 wrote:
    
    Hello everyone,
    
    One of our QA testers recently suffered a workstation failure. We installed a brand new workstation with Windows 7.
    
    This employee makes heavy use of MS Excel which needs to connect to several Oracle 10 and 11 databases to pull data to fill out in his reports.
    
    We followed this document to install an ODBC connector:
    
    https://tensix.com/2012/06/setting-up-an-oracle-odbc-driver-and-data-source/
    
    We successfully installed the Oracle driver. But the problem is that Oracle driver is not visible in Microsoft ODBC Data Source Administator.
    
    Can anyone shed some light on this?
    
    

    Did you install the 32-bit or the 64-bit driver?

    Are you looking at the 32-bit or the 64-bit ODBC DSA?

    You gotta love windows.  On 64-bit Win7, there is no pointy-clicky way to get to the 32-bit odbc admin.  You just gotta know where it is.

    Straight from the doc I wrote for our desktop support group:

    Open the ODBC admin tool. This can be tricky, depending on the combination of 32-bit vs. 64-bit software installed.

    IF OPERATING SYSTEM IS 64-BIT

    IF ORACLE CLIENT IS 64-BIT

    OPEN C:\Windows\System32\odbcad32.exe

    ELSE (client is 32-bit)

    OPEN C:\Windows\SysWOW64\odbcad32.exe

    END-IF

    ELSE (os and client are both 32-bit)

    OPEN C:\Windows\System32\odbcad32.exe

    END-IF

    NOTE: If configuring a 64-bit client on a 64-bit OS, or configuring on a 32-bit OS, the correct odbc admin tool is accessible through the Windows Control Panel. Only if configuring a 32-bit client on a 64-bit OS does one need to manually locate the executable in C:\Windows\SysWOW64\odbcad32.exe


This discussion has been closed.