OK, my hair is thinning fast enough without this. On WinTuke SP2, I've got a 9.0.1 full install of EE. I also have an install of the 8.1.7 client in a second ORACLE_HOME.
I've been using this setup fine and well until I installed Oracle Warehouse Builder into a separate ORACLE_HOME, then de-installed it after finding out it needs 9iAS. Then Quest products started flaking out, so Quest had me fiddle with the "LAST_HOME" registry entry. After that, the Microslop ODBC for Oracle driver fails to find the Oracle driver, stating: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr) And now, after uninstalling the 8.1.7 client, cleaning the registry, reinstalling and rebooting, I can only connect *HALF OF THE TIME* using 9i. The other half I get a TNS-12154, net name not found error. I'm using ONames for names resolution, but I don't understand what the hell is going on here. And seeing that it'll take me days to uninstall, reinstall, and reconfig I'd just as soon not do it. Anyone else have to deal with this hoo-ha that has a solution? I'd rather be at home diazinoning earwigs... <sigh> Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
