Dbvisualizer connecting SQL Server 2008 configuration

Software preparation

1.SQLServer drive ready to download on this connection: HTTPS://PAN.BAIDU.COM/S/1I4V1IVZ

(1). Extract the JDBC for SQL Server Drive.rar and get the Sqljdbc4.jar file

(2). Place the file under the installation directory D:\ installation tool \sqlserver\sqljdbc_6.0\chs\jre7

2. Install the dbvisual, install the package in

3. Load the drive into In Dbvisualizer Software:

3. Dbvisualizer Connection Database configuration (remote connection and local connection)

Run the software, the interface will prompt, such as, select "No Wizard"

4. In the "Database type" on the right side of the interface, select the "SQL Server" data type; "Driver (JDBC)" On the right side of the interface, select "SQL Server 2008" driver;

Note: URL format: jdbc:sqlserver://192.168.56.88:1433;D atabasename= "hotel_ebooking" contains IP, port number, Database name

It is best to shut down the firewall before connecting.

1) Note: The IP address or port number is wrong, or the firewall switch is on, it is easy to report the following problems:

TCP/IP connection to host 192.168.56.88 over port 1433 failed. Error: "Connection timed out: no additional information. Please verify the connection properties. Make sure that the instance of SQL Server is running on the host and that the TCP/IP connection is accepted on this port and that the firewall does not block TCP connections to this port. ”。

2.url Fixed Format jdbc:sqlserver://192.168.65.88:1433;databasename=hotel_ebooking

To solve the problem: Although the left side shows the connection is successful, but the following prompt, the table in the database does not show

How can I recover a data from a data table when I delete it by mistake

Dbvisualizer connecting SQL Server 2008 configuration