#1 2016-01-07 11:37:45

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?

Offline

#2 2016-01-07 12:40:22

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: DBExlorer with ZEOS

Uncomment
{.$define USEZEOS}

Michal

Offline

#3 2016-01-08 08:22:36

jkuiper
Member
Registered: 2014-11-24
Posts: 13

Re: DBExlorer with ZEOS

I've done it already (see documentation)

Offline

#4 2020-08-11 16:00:30

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.)

Offline

#5 2020-08-11 16:21:10

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,603
Website

Re: DBExlorer with ZEOS

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

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

Offline

#6 2020-08-11 16:31:43

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.

Offline

#7 2020-08-11 16:34:48

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,603
Website

Re: DBExlorer with ZEOS

big_smile

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.

Offline

#8 2020-08-11 18:24:11

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.

Offline

Board footer

Powered by FluxBB