Connecting to Microsoft SQL Server from Linux can be done through two different methods: ODBC and JDBC. Unfortunately, FreeTDS doesn’t connect to the newest versions of SQL Server unless you want to enable legacy connections.
The Microsoft JDBC Driver 4.0 for SQL Server, a Type 4 JDBC driver provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5 and 6.
The Microsoft ODBC Driver (Linux) For SQL Server provides native connectivity from Windows to Microsoft SQL Server and Windows Azure SQL Database on Linux.
Sang Shin’s online Java courses are very informative and are well paced. I highly recommend attending the free online courses even if you think you know all there is to know about Java.
The next and the 16th session will start on Sep. 1st, 2009. From this session, this course covers basic topics while “Java EE programming Advanced (with Passion!)” course covers more advanced topics. Just like other online courses I teach, this course is offered online only. For those of you who are not sure what it’s like to take this course online, please see What it’s like to take Sang Shin’s online courses. Just to set the expectation correctly, there is no real-time webcasting.
Did I mention the course is FREE? If you ever wanted to learn Enterprise Java, now is the time to sign up!