Which JDBC driver for MS SQL Server?



Hi,

As in the subject: which JDBC driver for MS SQL do you use?

I encounter weird problems when I want to connect to SQL Express 2005
database.

There are three drivers I had tested (with Execute Query java client):

Microsoft SQL Server 2005 JDBC Driver
http://msdn.microsoft.com/data/ref/jdbc/
- it doesn't work for me at all, cannot connect to database

jTDS JDBC Driver
http://jtds.sourceforge.net/
- it doesn't work also

SQL Server 2000 Driver for JDBC Service Pack 1
http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en
- it works very well, unfortunately I was unable to perform tasks like
'restore database', driver refused to execute such statement

Any ideas?

--
Mikolaj Rydzewski <miki@xxxxxxx> http://ceti.pl/~miki/
PGP KeyID: 8b12ab02
There are three kinds of people: men, women, and unix.

.



Relevant Pages

  • make any database have the ability of logging within 10 seconds
    ... With JDBMonitor,you can log the database execution in many ways,for ... JDBMonitor is licensed under the terms of the GNU Lesser General Public ... Almost every large database application includes its own SQL execution ... Make the application load the JDBMonitor JDBC Driver. ...
    (comp.lang.java.help)
  • make any database have the ability of logging within 10 seconds
    ... With JDBMonitor,you can log the database execution in many ways,for ... JDBMonitor is licensed under the terms of the GNU Lesser General Public ... Almost every large database application includes its own SQL execution ... Make the application load the JDBMonitor JDBC Driver. ...
    (comp.lang.java.programmer)
  • RE: CREATE DATABASE inside a transaction with Microsoft SQL 2005
    ... According to SQL Server BOL (Transact-SQL Statements Allowed in Transactions), "Create Database" is NOT allowed inside an explicit transaction. ... When I used the 2000 JDBC driver, I did not get any error message, but my Create Database call did NOT get rolled back. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Method cleanup failed while trying to execute method cleanup on ManagedConnection
    ... JDBC driver name: Microsoft SQL Server 2005 JDBC Driver ... Our application seems to be working fine but every time a connection is closed we get a stack trace in the log indicating that destroy failed and that a method is not supportd with "Caused by: java.sql.SQLException: This operation is not supported.DSRA0010E: SQL State ... We have used the same set up but using the SQL Server 2000 JDBC driver talking to a SQL Server 2000 database without a problem, the only difference is we switched it to use SQL Server 2005. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Tricky: java.lang.StackOverflowError due to recursive call in warning messages construction
    ... I got this problem with both SP2 and SP3 of the JDBC driver for SQL Server ... As PRINT statements are returned as warning messages, ...
    (microsoft.public.sqlserver.jdbcdriver)