[Fwd: Help with JDBC/OCI protocol]

From: Venkat Chandrasekaran <venkat_at_mail.fastpointcom.com>
Date: Sat, 28 Oct 2000 10:55:04 -0700
Message-ID: <39FB12F8.6BD0B96C@mail.fastpointcom.com>

Hello All:

I am trying to connect to a Oracle 8.1.6 server using JDBC/OCI protocol on Solaris. I obtained the right driver from ORacle's website and copied the zip file and the libjdbcoci8.so, set the LD_LIBRARY_PATH and ORACLE_HOME. I created a TNS name for the server using net config utility.

Now, I can successfully connect to the server using the tns name created, using SQLPLus utility. But when I try connecting to the same server using JDBC/OCI database url string I get: ORA-12154 (cannot resolve service name) error message. Have any one seen this? What could be the problem?

thanks Received on Sat Oct 28 2000 - 12:55:04 CDT