Re: Cannot connect to one Oracle DB using JDBC

davis@xxxxxxxxxxxx wrote:
...
The message I am getting looks like this

Driver: oracle.jdbc.driver.OracleDriver
Connecting to jdbc:oracle:thin:@db5.netaspx.com:1521:c0ujP0...

With Thin driver you connect directly to Oracle's
SQL listener. In this case tnsnames.ora is useless.
The connection string has to be ended with System
Identifier of your Oracle instance - not with service
name or service id. The Oracle SID is the unique name
of instance/database of your Oracle installation.

Alfred
.

Relevant Pages

  • Re: Does 2.0 still require ODP.NET to connect to Oracle?
    ... installation>> asks for all kinds of things in order to install. ... the oracle CLI installed, ... need that installed for the MS oracle provider. ... specify in the connection string. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Oracle Update Stored Procedure - cannot ROLLBACK in a distribu
    ... We are using Oracle 8.1.7.3. ... I have installed Framework v1.1 SP1 ... I have added enlist=false to the connection string ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Does 2.0 still require ODP.NET to connect to Oracle?
    ... I see that with framework 1.1 you had to download ODP.NET from ... oracle CLI installed, ... host names even matter when I'm going to be using a connection string ... client installation files, and don't need ODP.NET. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO Recordset
    ... use ODBC, and remember to put ODBC; in front of whatever they suggest. ... query, I'm now getting a "function sequence error". ... There has got to be something wrong with the Microsoft ODBC for Oracle ... However, if what you've got as the connection string is working for you, ...
    (microsoft.public.access.modulesdaovba)
  • Re: ODBC connection string
    ... I have setup an oracle10g database. ... connection string is? ... (SERVICE_NAME = orcl) ... I suggest that you use the Oracle ODBC client rather than the one ...
    (comp.databases.oracle.misc)