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

[Stefan W. <ste...@ao...>]

Hi,

The IOException indicates, that you can't reach the DB-Host.

Try one of the following on a command line:
* ping hostname
* telnet hostname portNumber

The telnet must be successfully.

But please, check if you have the right host and SID

/PFNGFD01.ukroi.tesco.org/ looks a little bit strange for a SID. Looks 
more like a DB-Hostname as a SID.

Stefan



Am 2012-03-05 15:55, schrieb hechesspee:
> 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?
>
> Regards
> Harsha