Microsoft ODBC for Oracle with multiple homes
430002Nov 28 2006 — edited Jan 12 2007Hi,
I have a server with some web applications and Oracle client 8i and 9i. I installed the 9i only few months ago. One of the applications is connected with an ODBC with the driver "Microsoft ODBC for Oracle".
I realized that my application is still using the client 8i even if I installed the 9i after the 8i. In my PATH variable, the oracle_home 9i is set first.
Can someone help me to know how to change the client of the ODBC connection? I tried to delete the data sources and create it again, I reboot the server, but nothing works.
Thank you