The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (“”): Data type 0x38 is unknown

Trying to connect to sqlserver DB and retrieve info and later insert to it.
On the server getting this error when trying to make a JDBC call with select.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

On my local machine everything is working fine. Not sure what needs to be done. Please need help on this.

  • Modify xml with namespaces
  • Need to improve performance query a table with millions of rows - SQL Server
  • Milliseconds wrong when converting from XML to SQL Server datetime
  • how to store multiple value in column in sql server
  • Creating a trigger in SQL Server for the appropriate table based on the logic
  • Cannot get FOR XML PATH to work
  • The classpath on server contains path to the below jars in this order.

    msutil.jar
    mssqlserver.jar
    msbase.jar
    sqljdbc4.jar
    

  • Java: INSERT INTO inside a loop using Result Test
  • Cannot connect to MSSQL due to Login-based server access validation failed with an infrastructure error
  • java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  • The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  • JPA - How to set string column to varchar(max) in DDL
  • Java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver On Android
  • One Solution collect form web for “The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (“”): Data type 0x38 is unknown”

    You have multiple Microsoft JDBC drivers on your classpath, and as a result you are connecting with the ancient MS SQL Server 2000 JDBC driver. Remove the old ones (ie msutil.jar, mssqlserver.jar and msbase.jar), and only leave sqljdbc4.jar. Also check if there is a newer version available than the one you are currently using.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.