gridhwa.blogg.se

Open Delphi 7, load the project package ". Download the "zeosdbo-6.6.6-stable" version from extract it to the folder.

Zeoslib is a database middleware for Borland development tools, including Delphi, C + + builder, and Kylix. Open Delphi 7, Place Tadoconnection, Tadoquery, Tdatasource, and Tdbgrid on the form, associate with each other, configure the Tadoconnection connection string for the following:ĭriver=  server=127.0.0.1  Database=world  User=root  password=a123 option=3 In the Tadoquery write query statement, set active to True, the data is displayed on the table as shown in:Īs above, first confirm the ODBC driver for MySQL installation.

Open Delphi 7 and Place Tadoconnection, Tadoquery, Tdatasource, and Tdbgrid on the form, associating with each other ( The practice here is to tadoquery the name of the Tadoconnection control on the Connection Property Association, tdatasource the query property to associate the actual name of the control on the Tadoquery, the order of the above, and so on), Configure the connection string for Tadoconnection, "provider" select "Microsoft OLE DB Provider for ODBC Drivers", Next, select "Use data source name", drop down to select the data source that you just configured, the other is not filled in, Test the connection as shown in: When you click "OK", you will see a new data source added.

Pop-up MySQL data source configuration, data source name arbitrarily, TCP/IP server for database address, user username, password password, database connection, point "test" to test the connection, as shown in: Switch to "System DSN" → "Add" → "MySql ODBC 5.1 Driver" as shown in: Must first have MySQL ODBC driver, I download is full install version, including MySQL server, various supported connection, Workbench, sample database, document, if no ODBC drive, can go to official website connector/odbc/download.įirst, confirm that you have installed MySQL ODBC driver, open "control Panel" → "Administrative Tools" → "data source", switch to "driver" page and view "MySQL ODBC 5.1 Driver" as shown in: Known as one of the most popular open source database, MySQL is widely used in various scenarios, ApsaraDB RDS for MySQL of Alibaba Cloud provided critical relief for companies, especially small and medium-sized enterprises affected by novel coronavirus (COVID-19).