Home / Questions / 1786
Accepted
Goerman
Asked: 2020-12-25 14:39:16 +0800 CST 2020-12-25 14:39:16 +0800 CST

How to connect Delphi with MySQL database?

  • 772

Equipment Configuration:

  • MySQL database version 5.5.16 (Installed with XAMPP)
  • Delphi 7
  • Windows 7 Enterprise (64-bit)

    Procedure followed:

  • Download and install MySQL ODBC Driver (mysql-connector-odbc-noinstall-5.3.4-winx64 ) ( http://dev.mysql.com/downloads/connector/ )
  • Create data source on Windows. (Control Panel / Administrative Tools / ODBC Data Sources)

    1. Choosing MySQL ODBC 5.3 Unicode Driver
    2. Configure connection parameters

    enter image description here

    1. Test connection in Delphi 7

    When setting the connection string in a Delphi form using ADOQuery, it allows me to correctly select the data source. But it gives me the following error when testing the connection:

    enter image description here

    “Connection test failed when starting provider. Unspecified error”

    Do I need to configure anything else to be able to connect to the database?

    • mysql

    2 Answers

    1. Best Answer

      Another option to connect to MySQL(and possibly more performant than using ODBC) is to use components ZeosLib.

      You can download them from Sourceforge here .

      All the best.

      • 3

    2. Well, as you described the steps are fine. I remember that in Windows 7 , Delphi 7 gave some unexplained errors if you didn't open it with administrator permission, so if you haven't tried it. I leave you a video that I made in 2010 where I explain the steps to make the connection of with Delphi 7 for you to review: See Video

      Cheers!

      • 0