Hello :) I want to connect via the Internet to my MySQL database, which is located on the server. For this, I use ODBC Data Sources - MySQL ODBC 3.51 Driver. I prescribe the database name, username (login) and password - I press the connect test button and get the error "SQL Request Error".

I need to create a "Data Source" in order to work from this database from Delphi (2007).

What do I need to do to establish a connection? Or maybe there is another way?

  • The path to the database is prescribed? Access to the database by the hoster is allowed? Use MyDAC - SoftR

1 answer 1

  1. Install MySql ODBC Driver
  2. Register username, password, database(catalog),host
  3. We specify as a data source our connection (for example, ADO components)

Or, or, bypassing ODBC, you can use third-party libraries, such as Zeos, with a description of installation and configuration .

Ps. Zeos will require libmysql*.dll