The Java connection sqlserver2008 msutil.jar|mssqlserver.jar|msbase.jar|sqljdbc4.jar driver package The latest software | Top ranking | Software classification | Special software | Forum post | Manufacturers Daquan

Your location: Home Page To Programming To The database classes Java, connect the sqlserver2008 driver package msutil.jar|mssqlserver.jar|msbase.jar|sqljdbc4.jar

The Java connection sqlserver2008 msutil.jar|mssqlserver.jar|msbase.jar|sqljdbc4.jar driver package  The Java connection sqlserver2008 driver package The score: 8

Other similar software

Software introduction

Software label: Sqlserver

The Java connection sqlserver2008 driver package Is for you to collect the driver software on the Java, download to allow users to better use SqlServer2008 after installation data base And to meet the needs of users, to green resources network to download it!

The Java connection sqlserver2008 driver package:

Java connection SQL Server 2008 to jar, which has 4 jar packet is 3 SQL Server 2008 The driver package there is a connection using the package.

 Java driver package

How to use Java to connect SqlServer2008 database?

Decompression is completed, you must enter < extract to the directory >\sqljdbc_3.0\chs, there is a thing we need

One is sqljdbc.jar, another is sqljdbc4.jar

This is the use of sqljdbc4.jar

First configure SA authentication:

Due to the installation of sqlServer2008 is to install the windows authentication, and did not add sqlServer identity of the user is sqlServer2008, so we add user:

Open the Microsoft SQL Server Managerment Studio and the windows authentication login, on the left side of the object Explorer - > Security > login name, right-click the sa-> attribute, add a password for the SA user, Choice SqlServer authentication, in the "state" option granted to connect to the database and log. Right click enable the root node object explorer, select properties - Safety of ->sqlServer and windows authentication mode, so as to create a SQL Server 2008 SQL server authentication user sa.

Connect to the sqlserver2008 database in the Java code in two ways, one is the SA authentication mode, the other one is mixed authentication mode:

Second: hybrid authentication mode, using the above java code url2.

Need the following operation in integrated mode:

Find you just unzip: enter the sqljdbc_3.0\chs\auth\x64, I was 64, if it is 32 x86, a file named sqljdbc_auth.dll to copy: C:\Windows\System32, good

The last is used by the sqlserver2008 dynamic port, you need to configure it:

Open the configuration tool for ->SQLServer configuration manager ->SQLServer network configuration ->MSSQLSERVER protocol ->TCP/IP is enabled, the TCP dynamic port in 0 are deleted, and then put a blank; pulled to the bottom of the list (IPALL), equipped with a fixed port, after you connect to the database using this port can be as follows: Map

 Java driver package

I used here is 1368, the database after the restart, can be connected with the above procedure.

Software screenshot

Download address

Click the error Unable to download software download or not available, please click on the error, thank you!

User comments

Popular comment

The latest comments

Comment View all comments ( 0 )

Please don't comment without meaning or words, all of our comments will have a manual review.
0 words: /500 (you need to display the comments after the audit)