Re: [Squirrel-sql-users] Unable to connect to Oracle DB using Squirrel

[Drav S. <ho...@re...>]

hechesspee wrote:
> Hi,
> I'm using Squirrel 3.3.0 and Oracle 9i client.
> I configured the Oracle Thin driver by using the ojdbc14.jar in the Extra
> Class Path
>
> Then I configured the alias as below (apart from login details)
>
> jdbc:oracle:thin:UKIRP251:1521:PFNGFD01.ukroi.tesco.org
>
> where  HOST = UKIRP251 and SERVICE_NAME = PFNGFD01.ukroi.tesco.org
>
> However I'm unable to connect and I'm getting the error as -
>
> IO exception. The network adapter could not establish the connection.
>
> Can anyone help me resolve this?

A thin client does not use the TNS name lookup.

The schema for thin clients is:

jdbc:oracle:thin:@<server>[:<1521>]:<database_name>

<server> would be PFNGFD01.ukroi.tesco.org I assume? It has to
be resolvable by DNS. <1521> is the port it connects
on and <database_name> is the schema you need to access.

Regards

D.