JDBC Connection SQL Server 2005 issues to be aware of

1. DriverName and Dburl should pay attention to write pairs, where drivername can be clear by looking at the loaded SQL driver jar packets.

The statement that loads the driver and URL paths in SQL Server 2000 is

String　driverName　=　"com.microsoft.jdbc.sqlserver.SQLServerDriver";
String　dbURL　=　"jdbc:microsoft:sqlserver://localhost:1433;　DatabaseName=sample";

JDBC connects to SQL Server 2005来, while the statements that load drivers and URLs in SQL Server 2005 are

String　driverName　=　"com.microsoft.sqlserver.jdbc.SQLServerDriver";
String　dbURL　=　"jdbc:sqlserver://localhost:1433;　DatabaseName=sample";

2. In SQL Sever to be set to allow Telnet

3. At the same time to open TCP/IP monitoring and set up a corresponding listening port