1

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

Britt Wescott
  • 568
  • 1
  • 9
  • 28
  • What's the issue? Can you provide a stack trace and/or error message from when the error happens. The MS JDBC drivers will work so it sounds like there's a potential configuration error. – Jeremy Mar 14 '11 at 05:55

3 Answers3

4

Yes, use JTDS.

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

gbn
  • 422,506
  • 82
  • 585
  • 676
1

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?

David Oliván
  • 2,717
  • 1
  • 19
  • 26
1

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.

Alex_M
  • 1,824
  • 1
  • 14
  • 26