Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server 2005 problems with driver

 
Mehul Mistry
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4028
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic