Re: oracle8 for NT JDBC question

Make sure the computer that is running the applet can find COLOSSUS (run PING COLOSSUS from a DOS prompt)--or use the IP address (stringly suggest). I would also suggest removing the username and password and passing them in as arguments. Here is an example: String username = "Scott";
String password = "Scott";
sourceCon = DriverManager.getConnection ( "jdbc:oracle:thin:_at_127.0.0.1:1521:ORCL", username, password);

I am not sure why, but I have had troubles connecting to _some_ Oracle databases when I include the username and password in the URL argument.

Aaron Freeman
Oracle Consultant
Adroit Corporation
alfreema_at_southwind.net

vagelis Hristidis wrote:

> I use Visual J++1.1 and Oracle8 on a WinNT4.0 computer.
> I took the jdbcapplet.java sample file,changed the connect_string to
> "jdbc:oracle:thin:scott/tiger_at_COLLOSUS:1521:ORCL";
> //COLLOSUS is my computer's name
> and recompiled it. I ran frontpage personal web server and I got this
> message:
> Loading JDBC driver oracle.jdbc.driver.OracleDriver
> Connecting to jdbc:oracle:thin:scott/tiger_at_COLLOSUS:1521:ORCL
> No more data to read from socket
>
> Do you have any idea what's wrong with it?
> Please mail to me.
> Thanks in advance.
>
> --
> Vagelis S. Hristidis
> Electrical and Computer Engineering
> National Technical University of Athens
> e-mail:exrist_at_cc.ece.ntua.gr
> URL:http://www.cc.ece.ntua.gr/~exrist
Received on Thu Jun 04 1998 - 00:00:00 CEST