MySQL is currently the most popular network database, which includes the following reasons:
Fast running speed
Free
Can run on Linux and some of the other platforms
Can be combined with Apache (a popular web server)
Can be combined with PHP perfectly
MySQL has an ODBC interface. If you are working with a Web server or MySQL server and want to associate data to a desktop application, an ODBC interface is a good way to do it. But if you're not operating on a server, the port that accesses MySQL is likely to be invalid, and you can only look for other ways to manipulate your data at this time.
Problems that exist
The issues mentioned are for the client. For security reasons, client programs typically choose a network representative from a single host, thus avoiding frequent logons to their systems on the network. Many hosts are able to provide the right conditions and MySQL, extensible frontpage,cgi and other site authoring tools. They can also meet hardware and software matching problems. This unique host can even provide a variety of tools to help you add or delete your MySQL database, but it only works in the basic MySQL repository format, which cannot be read directly into Access or other desktop programs.
The client program does not want to install MySQL on the server in its own unit, it can pass the data through my program, just run MySQL on my machine. I can manually get the data through the host repository. This process involves loading data into the database and transferring it to access via ODBC, and then sending the database content to the client. I don't mind the work done, but we should simplify some unnecessary work without relying too much on manual action.
Let me explain the above process again. First, the host on the Web page display data storage, through simple code and registration I get the database data, the reason for registration is for security reasons. Now, I use Microsoft's Web browser ActiveX controls to manipulate Access databases directly, which allows users to easily access MySQL data through the registration process, click a button, and then pass the data to the appropriate table in the Access database. As long as the data is in an Access database, users can use ODBC or their usual methods to pass data to the ERP system or other specialized systems.
Microsoft Access database
The Access database is fairly simple and consists of a number of data tables that list the data you want to add. In this section, I used the data table named Sales_data, which is made up of car data on a virtual website. Similarly, this data table should be identical to the MySQL data sheet on the host, both in name and structure. In fact, we will first generate a data table in Access (Figure a) and then transfer the data to MySQL on the local server via ODBC.
Figure A
The Access application opens with the Web Control Panel form open as well. In my routine, the program passed PHP registration on my server.
http://www.bkjia.com/PHPjc/631136.html www.bkjia.com true http://www.bkjia.com/PHPjc/631136.html techarticle MySQL is currently the most popular network database, and the reasons for this include: running fast free can run on Linux and some other platforms can be perfect with Apache (a popular web server) ...
