File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQL Server 2005 problems with driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Server 2005 problems with driver" Watch "SQL Server 2005 problems with driver" New topic

SQL Server 2005 problems with driver

Mehul Mistry
Ranch Hand

Joined: Feb 10, 2006
Posts: 43
Hello All
I have a problem while accessing Microsoft SQL server 2005. I get this error messages while accessing the database,"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown."

There is already a post in this form specify this problem, but somehow I was not able to post a reply over there and hence re-posting the problem (Please excuse)(the post is

The solutions mentioned above post was to change




I did the above change but still run into with same error. My database is deployed on MS SQL server 2005. I am using sqljdbc.jar file for my driver.

Can someone please help? Do I need a different jar or any other configuration?


Mehul Mistry
Ranch Hand

Joined: Feb 10, 2006
Posts: 43
Hi All
I got this one (after wasting lot of time on my silliness). In my JBOSS datasource file, I had mentioned connection string starting with "jdbc:sqlserver:". Where as at one the places in my application the connection string was for a different driver settings, starting with "jdbc:microsoft:sqlserver:...".

Because this mis-match, JBOSS had booted up with correct driver, but my application was using a different one and I ended with problems.

Thanks all.

Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

As a side note, class-path in a J2EE environment is extremely non-trivial. If you know what I mean by that statement you've probably had the misfortune of having to navigate it.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: SQL Server 2005 problems with driver
It's not a secret anymore!