Prob. with multiple homes, ODBC

I've got a perplexing problem with multiple homes and Microsoft's ODBC for Oracle driver. On a Win98 machine, I have the Oracle 8.1.5 client installed in an Oracle home called "Oracle". I also have Oracle Enterprise Manager 2.0.4 installed in an Oracle home called "OracleEM". The 8.1.5 client was installed first, OEM second if that matters.

The problem I have is that when my Oracle home is set to "Oracle" and I then try to connect to the database via MS ODBC, I get an error saying that SQL*Net is required but not installed (which I assume is an old message since SQL*Net has been replaced by Net8). However, the Oracle ODBC driver works, and I can connect using SQL*Plus, tnsping, and also via the MS OLE-DB driver from within an ASP page.

However, when I switch the Oracle home to "OracleEM", I can still use the Oracle ODBC driver, SQL*Plus, and tnsping, but when I try to use the MS ODBC driver or OLE-DB, I get a "TNS: unable to resolve service name" error. Yet somehow it will connect to another database- the sample db I created when I first installed the server and client.

I have made sure that the two tnsnames.ora files I use (one for each home) both have entries for the database I am trying to connect to. And doesn't the fact that some of the other tools work tell me that TNS shouldn't have a problem?

I'm very confused at this point. Does anyone know what the problem might be or where I should look next?

Thanks,

Paul Received on Thu Sep 23 1999 - 13:12:45 CDT