Shulou(Shulou.com)06/02 Report--

The main content of this article is to explain "how to connect JDBC to SQL Server 2005". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the method of connecting JDBC to SQL Server 2005"?

1. DriverName and dbURL should pay attention to write pairs, in which driverName can be identified by looking at the loaded SQL driver jar package.

The statement to load the driver and URL path 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 statement to load driver and url in sql server 2005 is

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

two。 Set to allow remote login in SQL SEVER

3. At the same time, open TCP/IP snooping and set the corresponding listening port.

At this point, I believe you have a deeper understanding of "what is the method of JDBC connecting SQL Server 2005". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.