Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

SQL Server 2005 problems with driver

 
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 https://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
 
author
Posts: 4173
29
jQuery Eclipse IDE Java
  • 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.
 
If you settle for what they are giving you, you deserve what you get. Fight for this tiny ad!
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic