Re: Which JDBC driver for MS SQL Server?

Mikolaj Rydzewski wrote:
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

Microsofts own works fine for me.

With SQLServer security that is.

Arne
.

Relevant Pages

  • Re: Dateadd in SQL statement not working
    ... Omigod, I thought you said you were using SQL Server, which is what my ... version of SQL used by Jet, which is the database usually used by Access): ... But my confusion is not totally resolved: Why are you using a Sybase ODBC ... driver to connect to either a Jet or a SQL Server database? ...
    (microsoft.public.inetserver.asp.general)
  • Re: SAP direct JDBC access
    ... > data with JDBC. ... > SQL Server. ... you can use a data source to hide the actual database ... driver used. ...
    (comp.lang.java.programmer)
  • Re: JDBC URL for Oracle Database With Failover (2 db servers)
    ... After you've loaded the driver, you can establish a connection using ... each form requires a database URL. ... For Oracle, the database URL has ...
    (comp.lang.java.databases)
  • RE: New JDBC 1.2 driver runs slower than JDBC 1.1; my db definitio
    ... If the support incident ends up verifying a slowdown in the new driver, ... New JDBC 1.2 driver runs slower than JDBC 1.1; ... I do think this would happen in general, not just for my database; ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)