Eclipse under Tanghan plugin even MSSQL combat

Source: Internet
Author: User
Tags command line microsoft sql server sql server driver mssql mssql server

The most recent project to use the Tanghan plugin plug-in in eclipse with the MSSQL database, how to start with, download Microsoft SQL Server Driver for JDBC, after three packages are Msbase.jar, Mssqlserver.jar,msutil.jar, some tutorials say that the three packets are written into the classpath, but the Tanghan database driver can only choose one, so this method does not work. There is a feasible method, that is, the above three packets extracted separately, and then the inside of the COM folder merged, the combination of methods can be overridden, that is, the second and third COM files in the same directory with the first COM folder, the system will be prompted to overwrite, the election is, Then at the command line with the jar to make this folder Mssql.jar package, the command is: Jar CVF mssql.jar com. The configuration is as follows: In database access view, as shown in Figure 1, the driver configuration is: Driver name: Microsoft MSSQL Server JDBC driver driver package Name: C:\dev\mssql.jar//Mssql.jar The path program driver class: Com.microsoft.jdbc.sqlserver.SQLServerDriver driver prefix: jdbc:microsoft:sqlserver://127.0.0.1:1433;d Atabasename=databasename Database configuration: Database connection name: Test driver name: Microsoft MSSQL Server JDBC Driver Program Driver class: Com.microsoft.jdbc.sqlserver.SQLServerDriver database connection: jdbc:microsoft:sqlserver://127.0.0.1:1433;d Atabasename=databasename Username: sa password: After matching as shown in Figure 2, circled the red line has disappeared, connect, success will be as shown in the figure, OK. As shown in Figure 3, the representation is already connected to the database.




Related Article

Beyond APAC's No.1 Cloud

19.6% IaaS Market Share in Asia Pacific - Gartner IT Service report, 2018

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.