Issues Connecting Ubuntu 10.4 to MS SQL DB thru Java

W开发者_如何学运维hat is the best way to allow a Java Application to connect to a MS SQL database in Ubuntu. I am currently trying jTDS but can not seem to get the connection to the server established.

Your best bet would probably to go with Microsoft SQL Server 2005 JDBC Driver 1.0

http://www.microsoft.com/downloads/en/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en

It's a very simple setup with some very nice documentation. Also, if your using a server name rather than an ip, make sure you have the FULL servername. For example abc123.thealphabet.com rather than just abc123. Hope this helps!