Solved

SQLException java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Posted on 2004-04-27
5
1,688 Views
Last Modified: 2011-10-03
Yesterday. All the things were OK.But when I turned on the computer this morning and ran  "java Testconnect"
I got the error: SQLException java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

By the way: yesterday when I used java Applet  in eclipse, I could connect  the server database. But the same applet class did not work in the webpages. SO, I copied "msutil.jar mssqlserver.jar msbase.jar" to C:\j2sdk1.4.2_04\jre\lib\ext and C:\Program Files\Java\j2re1.4.2_03\lib\ext  ,C:\Program Files\Java\j2re1.4.2_04\lib\ext  (the last two are installed by eclipse editor, I think).

 I deleted all of them now and re-setup the JDBC driver. it does not work.

TOMCAT 5.0, winXP, j2sdk1.4, JDBC driver
thanks.
0
Comment
Question by:chijingao
5 Comments
 
LVL 35

Expert Comment

by:TimYates
ID: 10926912
is the database on the same machine as the webserver?  If not, is the applet signed?
0
 
LVL 7

Expert Comment

by:searlas
ID: 10926917
Where is the database running?  Are you sure the database hasn't gone down (or network connectivity between you and the database.)
0
 

Author Comment

by:chijingao
ID: 10936965
The database server is a different machine. In fact, it is on my left. The Internet  connection is OK.

how can I  signe an applet ??
0
 

Accepted Solution

by:
laoyaobest earned 35 total points
ID: 10937927
0
 

Author Comment

by:chijingao
ID: 10948361
note: three sql 2000 server patches  3 are also needed. The patches can be download form microsoft.com free.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can I clean log of  running tomcat 7 server ? 3 126
using if condition without JSTL 2 109
withoutString  challenge 40 200
jsp insert to database example 2 26
If you thought ransomware was bad, think again! Doxware has the potential to be even more damaging.
In this increasingly digital world, security hacks are no longer just a threat, but a reality. As we've witnessed with Target's big identity hack 2013, Heartbleed in 2015, and now Cloudbleed, companies and their leaders need to prepare for the unthi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question