Hi;

I suggest you use the following url for the Sql Server sample as Northwind is the sample database shipped with Sql Server (like Scott with Oracle):

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind;SelectMethod=cursor

Also, why do you recomend against the MS drivers for Sql Server?

thanks - dave

because they are buggy

I've used the MS drivers for a couple of years and never had a problem with them. I have had problems with a 3rd party jdbc driver for Sql Server. So my experience has been that the MS drivers are more solid.

- dave

well, lucky you ;)

here is the list from top of my head:

Cannot call rs.getXXX("name") twice

Cannot in some case call rs.getXX() in another order than the resultset returns

Fails on some metadata calls

Inefficient compared to alternatives

and I bet you the jtds project can tell you more ;)

for basic usage its probably ok, but when you push it - then no dice ;)

all drivers has bugs - some has just more than others....

You might want to take a look at the latest version the getXxx() bugs were fixed awhile ago.

thanks - dave

I have not tried their new completely revamped version - only the version that have been around for ages without updates ;)

if it works for you fine, we recommend jtds until it has been proven otherwise ;)

(p.s. I forgot one thing: The MS drivers could not survive the hibernate test suite)