Zeoslib Portal

I use delphi 2005 architecture und zeos for xamp.
In the install kit of zeos I don't find the mysqllib.dll. My program shows error "Requested database driver was not found"
What can I do? Can you help me?

Just use the libmysql from your mysql server installation.
Not sure but it's probably included in your xamp installation. If not, just download a mysql distribution from the mysql site an use the dll provided there. We don't add it to the zeoslib package to avoid any licence trouble.
You can put the dll in your system path or just put it next to your projects' exe file.

Mark

Be sure to set the correct protocol on your ZConnection component because that gave me the same error when I started using ZEOS components (which was... yesterday)

Hallo mdaems
Thanks for your trouble, but it didn't work. It still shows the same message "Requested database driver was not found"
What else should I try?

What settings did you use on the TZConnection component?
Did you set host, database name, username, password and protocol (mysql or mysql5)?

Mark

I have changed the protocol in TZConnection of mysql4.0 to mysql and then the connection to the MySQL database worked. Should I somehow rename the dll?

Ich habe das Protokoll in TZConnection von mysql4.0 auf mysql geändert. Danach funktionierte die verbindung zur mysql-datenbank. Muss man die dll irgendwie umbenennen?

Some more information to understand what happens when loading the libraries for mysql:

Zeoslib looks for the protocol specific libraries first.
This is for
mysql 3.20 : libmysql320.dll
mysql 3.23 : libmysql323.dll
mysql 4.0 : libmysql40.dll
mysqld4.0 : libmysqld40.dll
mysql 4.1 : libmysql41.dll
mysqld4.1 : libmysqld41.dll
mysql 5 : libmysql51.dll and then libmysql50.dll
mysqld5 : libmysqld51.dll and then libmysqld50.dll
simple mysql protocol corresponds to mysql5

If these files are not available in the directory of the application exe or the system path and MYSQL_STRICT_DLL_LOADING is disabled in the Zeos.inc file, then zeos will look for libmysql.dll (or libmysqld.dll for embedded protocols)

Mark

Hurray it works. thank you

Well...

I'm trying to build a MySQL embedded application (very cool)

But there are NO libmysqld.dll or libmysqld51.dll or anything called "libmysqld*.dll" on my system.

I have MySQL 5.1 correctly* installed and i just made a search on Windows and there are no library with this name.

On "MySQL Server 5.1\bin" folder there are only a "mysqld.exe" file, but of course this is another thing...

Well, where to find this dll?

*There are a option on installation time to make this dll available?

Take a look at [zeos dir]\lib\mysql

Here there are all libmysqld*.dll

seawolf wrote:Take a look at [zeos dir]\lib\mysql

Here there are all libmysqld*.dll

No!

I have the file "ZEOSDBO-6.6.4-stable.zip" and there are no lib folder into it.

mdaems said this is to avoid legal issues...

So the question is UP:

WHERE TO FIND THE LIBMYSQLD*.DLL?!

Download a snapshot from here

Then extract that dll

The only right answer should be : get it from mysql! Doesn't matter if it's a Community (free) or Enterprise version.

Just donwload mysql server (5.0 or 5.1) for windows from the mysql.com website. There you'll find an Embedded subdirectory, containing a debug or normal dll. This way you always have the most bugfixed embedded server version.
Versions 5.0 and 5.1 should work with zeoslib.

Mark

BS!

mysql website offers no dll's, you need to download a server.
U will c that no server's dll's will work. all current mysqlservers (4.1-6.1) does not work. funny if you download 1.2 gb of data for nothing.

even all snapshot's contained dll's are alle incompatible.
even zeos does not search for libmysql(d)(4-5.1).dll

guys ull c me never ever again!

nocturne wrote:BS!

mysql website offers no dll's, you need to download a server.
U will c that no server's dll's will work. all current mysqlservers (4.1-6.1) does not work. funny if you download 1.2 gb of data for nothing.

even all snapshot's contained dll's are alle incompatible.
even zeos does not search for libmysql(d)(4-5.1).dll

guys ull c me never ever again!

Well... The answer was here all the time:

http://zeos.firmos.at/viewtopic.php?t=2400&highlight=

Pay attention on the 3rd paragrahp of the text...

You need to download the FULL version of MySQL, not the "essentials" package.

The full version contais the embed dll up to date. Try to read the entire topic on the above link, there are a issue on replace the original dll with the updated one. If you replace only the DLL the ZeosLib Sample "MySQL embedded" will not work...

Bye Bye dude...