mORMot Open Source

jkuiper

Member

Registered: 2014-11-24

Posts: 13

DBExlorer with ZEOS

I've installed ZEOS 7.2 in My Delphi 10 Seattle. Loaded the source in the IDE and ran it.
This gave me the opportunity to create a connection. Therefore I select ZEOS which my MySQL database will be connected. I put the libmysql.dll in windows\system32.

The database connection will not be executed:

Project SynDBExplorer.exe raised exception class EZSQLException with message 'Requested database driver was not found'.

Do I have something to do extra to connect my MySQL/MariaDB database with ZEOS?

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: DBExlorer with ZEOS

Uncomment
{.$define USEZEOS}

Michal

jkuiper

Member

Registered: 2014-11-24

Posts: 13

Re: DBExlorer with ZEOS

I've done it already (see documentation)

leus

Member

Registered: 2012-09-05

Posts: 79

Re: DBExlorer with ZEOS

I'm having similar issues. What should I put in "Server" to connect to MySQL using ZEOS?

localhost:
Requested database driver was not found

mysql:localhost
Project SynDBExplorer.exe raised exception class EZSQLException with message 'SQL Error: Unknown database 'localhost' Code: 1049 Message: Connect to "localhost" as user "root"'.

mysql:127.0.0.1
Project SynDBExplorer.exe raised exception class EZSQLException with message 'SQL Error: Unknown database '127.0.0.1' Code: 1049 Message: Connect to "127.0.0.1" as user "root"'.

Of course, I can connect without problems with any other program (heidisql, my own anydac based programs, etc.)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: DBExlorer with ZEOS

Check e.g. https://synopse.info/files/html/Synopse … #TITLE_192

TSQLDBZEOSConnectionProperties.URI() allows to generate the proper URI.

leus

Member

Registered: 2012-09-05

Posts: 79

Re: DBExlorer with ZEOS

Thanks, I had just found out by debugging line-by-line what the constructor needed. It was quicker than loading that file in my browser, let alone navigating it.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: DBExlorer with ZEOS

Also check the documentation of TSQLDBZeosConnectionProperties
https://synopse.info/files/html/api-1.1 … PROPERTIES
- faster to download for sure...
Also part of the source code of the unit, as comments.

leus

Member

Registered: 2012-09-05

Posts: 79

Re: DBExlorer with ZEOS

Yes, I'm slowly making progress.

I think people don't say this as often as we should - thank you for your incredible work, Arnaud.