SqlException

[gsuns82]

hi,
my java code:
****************

 import java.sql.*; 
public class sqljdbc
{
public static void main(String[] args) 
{
try
{
String url = "jdbc:microsoft:sqlserver://";
//String serverName = "localhost";
String serverName = "ow8";
String portNumber = "1433";
String databaseName = "sundar";
String userName = "sa";
String password = "sa";
String selectMethod = "cursor"; 
//String url="jdbc:microsoft:sqlserver://"+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";,"+userName+","+password;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection(url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";",userName,password);
//Connection conn = DriverManager.getConnection(url);
Statement st=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=st.executeQuery("select * from paging");
while(rs.next())
{
System.out.println(rs.getString(1));
} 
}
catch (Exception e)
{
e.printStackTrace();
 
}
}
}
 

EXCEPTION GOT:
*********************

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.<in it>(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(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at sqljdbc.main(sqljdbc.java:18)

can any one resolve this exception?????????????

thanks in advance.............

[r035198x]

There could be several reasons for this error. Try the suggestions here and post if there is still a problem.

[gsuns82]

There could be several reasons for this error. Try the suggestions here and post if there is still a problem.

thanks 4 ur reply,
I have followed the instructions which are given in www.websina.com but still getting the same problem....can u guide me further??? any other solutions???

[JosAH]

Print out that complicated String before you pass it on to the getConnection()
method. Check if it is correct; it seems it isn't.

kind regards,

Jos

[gsuns82]

Print out that complicated String before you pass it on to the getConnection()
method. Check if it is correct; it seems it isn't.

kind regards,

Jos

I tried the following connection url suggested by Microsoft.com but still having the same problem..

connection urls wic i tried:::
********************************
jdbc:microsoft:sqlserver://localhost:1433;databaseName=sundar;UserName=sa;Pas sword=sa

any idea on this url????

regards,
suns82.

[JosAH]

This may seem trivial but check it out nevertheless:

- is your database engine running?
- does it listen to the port you mentioned?
- does a user 'sa' (the same password) exist?
- try 127.0.0.1 instead of localhost.

kind regards,

Jos

[gsuns82]

This may seem trivial but check it out nevertheless:

- is your database engine running?
- does it listen to the port you mentioned?
- does a user 'sa' (the same password) exist?
- try 127.0.0.1 instead of localhost.

kind regards,

Jos

thanks Jos,i have tried things wat u mentioned except dns '127.0.0.1',let me try this,this can the final hope...

regards,
sundar.