Prob. with multiple homes, ODBC

Pardon me if this post shows up twice, but my news server really stinks.

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

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 23 1999 - 16:44:59 CDT