This discussion is archived
2 Replies Latest reply: Oct 19, 2012 4:04 AM by Tridus RSS

it's never done that before - 3d edition

EdStevens Guru
Currently Being Moderated
Oracle clilent 11.2
Windows 7 professional, 64bit

App support comes to me with problem. New PeopleSoft client installation doesn't work. Error messages indicate library mismatch.
Oracle client newly installed, looks like a 64bit client but needs 32 bit.
No problem, I've fixed stuff like this hundreds of times.

First, Rip out the current oracle installation: delete C:\Program Files\oracle; delete c:\app\oracle; delete the references to Oracle from hklm\software\odbc; delete all of hklm\software\oracle; delete
references to oracle from the system PATH environment.

Next, re-install oracle run-time client, 32bit. Installation goes without a hitch, and I am able to connect with sqlplus.
Next, run the installer again, selecting 'custom' and selecting the oracle odbc component; override suggested default of a new OHOME and select the just installed home. Again, something I've done hundreds of times.

Next, test the ODBC. Open the odbc config tool and start to set up a new DSN, but oracle is not listed among the available drivers .... ?!?!?. Checked the registry, hklm\software and before I look into ODBC, I can see there is no entry for ORACLE. ?!?!?

Yet, I can connect with sqlplus, and the apps guy is able to complete the configuration of the PeopleSoft client and it works.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points