Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
Cloud-based technologies and services will continue to grow in popularity in 2017 thanks to the simple, scalable and cost-effective solutions they deliver. Here are three areas where cloud adoption is poised to really take off.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now