aspose file tools
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


Win a copy of Meteor in Action this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Server 2005 problems with driver" Watch "SQL Server 2005 problems with driver" New topic
Author

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 http://www.coderanch.com/t/305181/JDBC/java/SQL-Server-Microsoft-JDBC-driver#1383889)

The solutions mentioned above post was to change

jdbc:sqlserver://<DB_SERVER>:<PORT>;SelectMethod=cursor;DatabaseName=<DB_NAME>

to

jdbc:sqlserver://<DB_SERVER>:<PORT>;SelectMethod=direct;DatabaseName=<DB_NAME>


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?

Thanks
Mehul



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.

Regards
Mehul
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740
    
  10

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: http://aspose.com/file-tools
 
subject: SQL Server 2005 problems with driver