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.
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.