JDBC Drivers for SQL Server 2008

I am trying to connect from a Java app to a SQL Server 2008 database, in Eclipse. So far I have tried using SQL Explorer and the latest JDBC drivers from开发者_开发知识库 Microsoft, but I haven't had any luck so far. Are there more effective ways of connecting to SQL Server 2008 from a Java app?

Thanks

Yes, use JTDS.

The MS drivers are frankly rubbish. The JTDS ones support Windows Authentication and SSL from non-Windows clients too

You can try using the JDBC-ODBC bridge, connecting to SQL Server as a ODBC source, JDBC-ODBC Bridge Driver, but it is not recommended if you can avoid.

You can try different SQL Server JDBC drivers from third-party, like jTDS.

What kind of problems are you facing?

try a generic odbc if you're running your software on windows. you just need to install the odbc windows-driver for your sql 2008 server.