I am using netbeans
ide with MS-SQL 2000 Server. My problem is that
When I am using
Data is shown on command prompt but when i am using rs.first() or rs.Previous() or rs.last() then it shows error on it
com.microsoft.sqlserver.jdbc.SQLServerException: The requested operation is not supported on forward only result sets.
BUT WHEN I CHANGE THE STATEMENT LIKE
com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.
OR WHEN I CHANGE THE STATEMENT LIKE
com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.
OR WHEN I CHANGE THE STATEMENT LIKE
com.microsoft.sqlserver.jdbc.SQLServerException: The requested operation is not supported on forward only result sets.
OR WHEN I CHANGE THE STATEMENT LIKE
com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.
LAST but not least: While using INSERT,UPDATE,DELETE
cnn.createStatement() is working perfectly.
I am using following jar files
sqljdbc4.jar
jtds-1.2.5.jar
I do not know where i make mistake? Can anybody please help me out in solving this problem.