Download the "ZEOSDBO-6.6.6-stable" version from and unzip it to a folder. ZeosLib is a database middleware for Borland development tools, including Delphi, C++ Builder and Kylix. 0.1 Database=world User=root Password=a123 Option= 3 Configure the connection string of TADOConnection as the following:ĭriver= Server= 127.0. Open Delphi 7, place TADOConnection, TADOQuery, TDataSource and TDBGrid on the form, and associate them with each other. Same as above, first confirm the installation of the MySql ODBC driver. Write a query in TADOQuery, set Active to True, and the data will be displayed on the table, as shown in the following figure: Open Delphi 7, place TADOConnection, TADOQuery, TDataSource, and TDBGrid on the form, associate them with each other, configure the connection string of TADOConnection, select "Microsoft OLE DB Provider for ODBC Drivers" for "Provider", and then select "Use Data source name", drop down to select the data source just configured, no need to fill in the others, test the connection, as shown below: Pops up MySql data source configuration, the data source name is arbitrary, TCP/IP Server is the database address, and the User user name, Password, the database connected by Database, click "Test" to test the connection, as shown in the figure below:Īfter clicking "OK", you can see that a new data source has been added. Switches to "System DSN"→"Add"→"MySql ODBC 5.1 Driver", as shown in the following figure: confirm that the MySql ODBC driver is installed, open "Control Panel" → "Administrative Tools" → "Data Source", switch to the "Driver" page, and view "MySql ODBC 5.1 Driver", as shown in the figure below : Must have MySql ODBC driver first, I downloaded the fully installed version, including MySql server, various supported connections, Workbench, sample database, documentation, if there is no ODBC driver, you can download it from the official website. Software environment: Delphi 7, mysql-installer-5.5.15.0 1.
Here, I only record the methods I have tested in case I need them.
There are many articles about Delphi connecting to MySql database on the Internet.
0 kommentar(er)
