| 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
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
|
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.
|
My Blog: Down Home Country Coding with Scott Selikoff
|
 |
 |
|
|
subject: SQL Server 2005 problems with driver
|
|
|