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

This article mainly shows you "how to use JDBC to connect SQL Server 2008", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to use JDBC to connect SQL Server 2008" this article.

The reason for the connection error is that JDBC connection SQL SERVER 2008 uses a dynamic port mechanism. According to the previous method, the connection will report that the connection cannot be connected, but in fact, there is no problem with the port being written correctly. The connection method is as follows:

1. Microsoft currently does not release a special JDBC driver for JDBC connection SQL Server 2008, just use SQL Server 2005. However, it should be noted that the new feature of JDBC connection SQL Server 2008 cannot be used, and this must be used after the release of the dedicated JDBC. Download address:

Microsoft SQL Server 2005 JDBC Driver 1.2

Http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=c47053eb-3b64-4794-950d-81e1ec91c1ba

2. Set the port to a fixed port:

SQL Server configuration Manager, which can be set according to the figure

Note: dynamic port can be disabled if the dynamic port is set to empty

JDBC connection SQL Server 2008 connection:

Jdbc:sqlserver://192.168.3.6:1368;databaseName= database name; user= user name; password= password; above is all the content of this article "how to connect to SQL Server 2008 using JDBC". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.