SqlException
hi guys,
I am trying to use SqlServerDriver,i got an exception on which
i cant resolve.....
source 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";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection(url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";",userName,password);
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 that i got:
*********************
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown 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:17)
can anyone resolve this exception?
thanks in advance

