-
1. Re: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
gregs Nov 26, 2004 11:44 AM (in response to gregs)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. -
2. Re: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
tlthomas Nov 26, 2004 1:00 PM (in response to gregs)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.
Cheers.
Tom -
3. Re: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
gregs Nov 29, 2004 4:26 AM (in response to gregs)Hi Tom,
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.
http://www.akadia.com/services/sqlsrv_jdbc.html
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. -
4. Re: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
booney Jan 28, 2005 2:38 AM (in response to gregs)hi gregs:
i m also meet this problem before
After i setup the sqlserver2000 sp3 it works ok.
Wish will help u -
5. Re: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
safrye Jun 8, 2005 12:19 PM (in response to gregs)With SP3 on Xp Pro, this works fine - though I had to tweak SQl Server a little.