Friday, August 6, 2004 05:13 AM
You need first a JDBC driver for SQL Server. There are several possibilities:
I recommend the jTDS driver. Its sufficiently fast and implements almost all features. I discourage to use Microsofts own driver, because it does not implement all key features (e.g. BLOBs). For a complete list of all drivers consult SUN's JDBC pages
After adding the Jar files of the driver to the classpath, you can use it like any other JDBC driver. Driver class name and the syntax of the connection URL are usually described in the driver's documentation. Therefore, you should read it.