Solved

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

Posted on 2004-04-27
5
1,696 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
session bean client machine 9 66
authenticate preemptively soap ui option 3 170
best way to search/remove a file from an EAR file 3 116
mysql jsp example issue 32 71
This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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