PDA

View Full Version : JDBC Error establishing socket


terry
01-05-2004, 02:16 AM
We are trying to resolve a JDBC Error establishing socket. Any help is much appreciated!

Details: java class files compiled in jdk 1.14.
All files (classes and database) are loaded on the dicountasp.net server.
Database: MS SQL. We are using SQL 2000.
It "seems" that the socket on both ports 1433 and 14330 are ok.
Our code renders the charts on the page but not the data portion.
Browser: IE 6.0.2800

Here is our code:
---------------------------
dbCon = java.sql.DriverManager.getConnection(
"jdbc:microsoft:sqlserver://mssql03.discountasp.net:1433;databaseName=DB_, "username",
"password");

------------------------------------------------------
Below is the Error:

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

at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnecti on.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplC onnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknow n Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at untitled1.SliderContainerApplet.getConnection(Slid erContainerApplet.java:427)

at untitled1.SliderContainerApplet.getdatafromdatabas e(SliderContainerApplet.java:117)

at untitled1.SliderContainerApplet.jbInit(SliderConta inerApplet.java:108)

at untitled1.SliderContainerApplet.init(SliderContain erApplet.java:44)

at sun.applet.AppletPanel.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Error Trace in getConnection() : [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

java.lang.NullPointerException

at untitled1.SliderContainerApplet.getdatafromdatabas e(SliderContainerApplet.java:126)

at untitled1.SliderContainerApplet.jbInit(SliderConta inerApplet.java:108)

at untitled1.SliderContainerApplet.init(SliderContain erApplet.java:44)

at sun.applet.AppletPanel.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)