The database is not connected to a general approach

Source: Internet
Author: User

Today, I built a set of development environment.

The development environment is made up of two machines, and my old notebook A is now used as a server, specifically for use as a database server. Another machine, B, is used as a development machine. After installing all kinds of software, now my development machine B to Access database Server A, but, not even!!!

The operating system and software are described first. My two machines are used Win7 operating system, database server installed DB2 database (tested, database installation is correct, to provide data services), development of machine development software is eclipse. Now running a system that wants to access the data in the DB2 database, but not even up. Start searching for solutions on the web, and finally, summarize the following steps to resolve problems with this type of network service.

Three-Step solution:

①. See if two networks are up, ping, and determine network problems

②. See if the DB port can be connected, Telnet, and determine if the firewall is limited

③. If the above ①② is OK, then look at the DB account authorization is authorized to access the machine IP, determine the DB permissions control

My problem is that there is a problem at the ②. It turns out that the default firewall of the Win7 system defaults to the 50000 port access that does not open the db. As a private development environment, my solution is simply to turn off the firewall of the database server's machine, so that the problem is solved. In fact, in the production environment, it is best not to do so, to a dedicated management personnel to open this port access rights. I'm just lazy and I didn't do it. For details on how to open Win7 port access, please refer to the solution provided by http://jingyan.baidu.com/article/f96699bbadafca894f3c1b7a.html, which I am not elaborating.

The database is not connected to a general approach

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.