I have since found a solution to my problem....and this will be specific to all drivers for JDBC with MS SQLSERVER 2000.
The MS Driver (Recommended) will give a SOCKET EXCEPTION. Others may give a NetworkIO Exception or something similar.
The bottom line is that using JBoss App server with JDBC Driver to connect to a DB on MS SQL SERVER2000 will NOT WORK unless the MS SQL SERVER2000 is running on a Server thats running a MS Server Operating System.
In my case I was trying to connect to a network desktop (XP) that was running MS SQL SERVER2000.
This to me is crazy!! and I'm not going to buy it being a "security reason" why this is in place. This is purely for licensing and MS trying to keep everyone using MS products.
I may have been foolish in all of this...but after days of digging I found only one document that described a setup like this and it worked. There may be some config guidelines along these lines on the MS website but I couldnt find any.
I'm also having problems getting jboss to understand MS SqlServer2000. What was the reference you found? Seems like the "Getting Started" article leaves out critical information.
My setup was fine...my SQL Server setting were ok and my xml files and jar files for JBoss were all fine.
The only thing I didnt know what that SQL Server had to be running on a server running a MS Operating System.
There's a little scenario in this link that describes it.
There's plenty of details on the web (and in these forums) that are great for making sure you have the right driver etc... and connection properties set correctly..... but I didnt find anything about the fact you need to run SQL Server on a MS Server.
I hope this helps a bit.
i m also meet this problem before
After i setup the sqlserver2000 sp3 it works ok.
Wish will help u
With SP3 on Xp Pro, this works fine - though I had to tweak SQl Server a little.