Re: Which JDBC driver for MS SQL Server?

On 25.09.2006 14:32, Mikolaj Rydzewski wrote:
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?

We use jTDS. It might be helpful if you provide actual errors you get. "It does not work" is pretty unspecific.

Kind regards

robert
.

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.programmer)
  • 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)
  • Re: Error when binding value to prepared statement with SQL Server 2005
    ... Database version is 9.0.1399 ... > Arto Basmadjian wrote: ... >> I'm using the latest jdbc driver to connect to an Sql Express ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Possible Type Conversion Defect
    ... I'm developing a large application using SAP Web Application Server ... with JDBC Driver Beta 2 for SQL Server 2005 and I'm getting the SAME ... There's any solution or I must change my strategy to don't choice SQL ... a JDBC driver attempts to convert the underlying data to the Java ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: collation SQL_EBCDIC037_CP1_CS_AS
    ... SQL 2005) ... The error message I got is "Codepage 950 is not supported by the Java ... I had no problem to use JDBC 1.1 with collation ... Are you able to reproduce this issue with the SQL Servef 2005 JDBC Driver? ...
    (microsoft.public.sqlserver.jdbcdriver)