Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method suitable for remotely connecting database in intranet environment

A technology of remote connection and database, applied in the field of remote connection to database, can solve the problem of inability to connect to MySQL database remotely, and achieve the effect of saving transmission time, implementing simple code and simple protocol.

Inactive Publication Date: 2021-11-12
济南朗宁电力科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of the above situation, in order to overcome the defects of the prior art, the present invention provides a method suitable for remotely connecting to a database in an intranet environment, and solves the problem of being unable to remotely connect to a MySQL database in an intranet environment. The protocol is simple, and the code is easy to implement. The communication speed is fast, allowing the transmission of various data and saving transmission time

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method suitable for remotely connecting database in intranet environment
  • Method suitable for remotely connecting database in intranet environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present invention, not all of them; based on The embodiments of the present invention and all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0016] Such as Figure 1-2 As shown, the present invention is suitable for a method for remotely connecting to a database in an intranet environment, comprising the following steps:

[0017] 1) The client establishes a connection with the server: use hypertext transfer protocol, host address and path to establish the connection between the client and the server;

[0018] 2) Send request: After the connection is successfully established, the cli...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method suitable for remotely connecting a database in an intranet environment. The method comprises the following steps: 1) establishing connection between a client and a server; 2) sending a request; 3) querying data according to the request; 4) the server responding; 5) the client obtaining data; and 6) operating data. The invention belongs to the technical field of network transmission, particularly relates to a method suitable for remotely connecting a database in an intranet environment, solves the problem that a MySQL database cannot be remotely connected in the intranet environment, and is simple in protocol, simple and convenient in code implementation, high in communication speed, allowed to transmit various data and capable of saving transmission time.

Description

technical field [0001] The invention belongs to the technical field of network transmission, and specifically refers to a method suitable for remotely connecting a database in an intranet environment. Background technique [0002] The program remotely connects to the MySQL database in two ways. The first is to use ADO to connect, and the second is to use the API that comes with MySQL to connect. To connect to the MySQL database through ADO, you need to install the MyODBC server program, and the MyODBC version must be consistent with the MySQL version; to connect to the database through the api that comes with MySQL, use the connection method that comes with MysqlClient to connect with TCP / IP, compared to ADO. Said that using its own API connection is extremely simple and efficient. The intranet distribution area is limited, and it is a closed network, which can prevent information leakage and external network virus attacks to a certain extent, and has high security. But no...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): H04L29/08G06F16/24
CPCH04L67/02H04L67/141G06F16/24
Inventor 翟拥华田育丰任在利马黎黎
Owner 济南朗宁电力科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products