Connecting to SQL Server 2000
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Indrajit_Guha
Posted On:   Friday, August 6, 2004 03:04 AM

I have an SQL Server 2000 running in Win NT server by the name of "ntserver"


The database is called "smdatabase"


How do I create a connection to this database?

Re: Connecting to SQL Server 2000

Posted By:   Anonymous  
Posted On:   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.

About | Sitemap | Contact