Solved

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

Posted on 2004-04-27
5
1,697 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

How many times a day do you open, acknowledge, or close an IT incident? What’s your process? Do you have a process depending on the incident, systems involved, and other factors? New Relic Alerts gives you options for how you interact with notifica…
The goal of this blog is to: > note what has impeded us from reaching effective life on-call > provide 3 steps to mastering life on-call > highlight what will be achieved with effective life on-call
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

738 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