Re: Java - JDBC Oracle Thin Driver problems

I think that the problem is that you have not put an @ sign before the host name. Try "jdbc:oracle:thin:@192.168.1.4:1521:PROD". You can also add the user name if you want to log in at this point as well e.g. "jdbc:oracle:thin:scott/tiger_at_192.168.1.4:1521:PROD".

Regards
Gary Smith

john palmieri wrote:

> I'm trying to connect to an NT server running Personal Oracle 7.3.2. I
> am using the JDBC Thin Client from Oracle and am trying to connect using
> this URL - jdbc:oracle:thin:192.168.1.4:1521:PROD. When I do this I get
> a java.sql.SQLException: Connection refused. I think the problem can
> eather be that I have the wrong port number, wrong SID or I need to set
> up DNS insted of using the the IP numbers. Can anyone tell me how I can
> set the port and SID? I took a look at the SQL*Net easy setup but it
> came back with an error that a file was already modified and I didn't
> want to mess anything up.
>
> John Palmieri
> On-Line Design

--
*************************
Gary Smith
CERN, Geneva, Switzerland
Email: Gary.Smith_at_cern.ch
Tel:   +41 22 7673416
*************************