Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-04-27
5
Medium Priority
?
1,709 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 140 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
In this article, I’ll show how research, determination, and use of modern technology helped me solve a DNA mystery.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

719 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