This content has been marked as final. Show 2 replies
859262 wrote:You could hack the registry, but unless you know what you are doing with it, I don't recommend it.
I installed the 64bit 11g client on a windows 2008 R2 server. created some connections. Then found that i needed the 32 bit dirver. So i installed that one as well but i was unable to create connections. So i uninstalled both the 64 and 32 bit versions but did not delete the ODBC connections i had created. Now when i try to delete them i get a pop up saying that " the setup routines for the Oracle in OraClient11g_home1 ODBC driver could not be found. Please reinstall the driver." when i try to install it wants to install in a client_2 folder and will not let me install in client_1. I can't delete client_1 because some of the files are in use (i assume because of the odbc connections?). How do i remove these so i can just start over with a clean slate as far as oracle goes?
You said "when i try to install it wants to install in a client_2 folder and will not let me install in client_1". Please explain. My normal procedure for installing a client with odbc is to first do a standard installation of the run-time client. Next, because the first did not include the ODBC drivers, I go back and do a 'custom' install and select the ODBC component. Now, by default it is going to prompt me to install into a new home, but you can easily override that. The 'software location' field is a pick list, you should be able to open it and select your original home.
The files are probably in use due to something else like the OracleMTSRecovery Service, which seems to not uninstall correctly sometimes. Removing all that stuff (and the rest of Oracle) is a bit of thing. (edit - You could take a look here for one suggestion, but I make no promises as to if it works or not: http://stackoverflow.com/questions/8450726/how-to-uninstall-completely-remove-oracle-11g-client )
But removing the ODBC connections is pretty easy. They're in the registry. Depending on if they're user or system DSNs, they're either in HKEY_CURRENT_USER or HKEY_LOCAL_MACHINE
You'll see them listed under there if you expand that one, and can just delete them. That's for 64 bit ones, 32 bit ones are in \Software\Wow6432Node\ODBC\ODBC.INI
Edited by: Tridus on Jan 2, 2013 1:12 PM