#994 Not able to connect to oracle 8.2

open
5
2011-06-20
2011-06-17
No

I used classes111.zip for thin oracle connection to connect to oracle 8.2.
I encountered with "Io exception: The Network Adapter could not establish the connection". But when I try to connect to database using some other SQL client it works..

Please help me

Discussion

  • progs_backup

    progs_backup - 2011-06-17
    • assigned_to: nobody --> manningr
     
  • Rob Manning

    Rob Manning - 2011-06-17

    My experience with this error mesage is that either the jdbc url is incorrect, or the listener is not listening to the port that you think it is. It is easy to verify the url. Suppose the url is something like this:

    jdbc:oracle:thin:@servername:port:sid

    If you have telnet installed on the machine that SQuirreL is running on, then drop to command line and issue the following command:

    telnet servername port

    Where servername and port are taken from the jdbc url. If you cannot connect successfully, then there is a problem with the route to the database, or the listener is not listening to the port you think that it is.

    Rob

     
  • Rob Manning

    Rob Manning - 2011-06-17
    • status: open --> pending
     
  • progs_backup

    progs_backup - 2011-06-20

    I copied the working URL from other SQL Client. The other SQL client connects correctly to the database. But, I want to use Squirrel.
    Still I am getting, "Io exception: The Network Adapter could not establish the connection". This happens only with oracle 8.2 dbs.

    Please help me.

     
  • progs_backup

    progs_backup - 2011-06-20
    • status: pending --> open
     
  • progs_backup

    progs_backup - 2011-07-15

    Can anybody help?

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks