File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3697
    
    5

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server 2005 problems with driver
 
Similar Threads
Cannot create PoolableConnectionFactory
OC4J deploment problem Leaked Connection Related
Connect to SQL 2005 with JBOSS 4.0.3
connectionURL to SQL Server 2005
SQL Server 2005 & Microsoft JDBC driver