Zeoslib Portal

I understand. So, it's breaking code legacy.

Have both for same app. How do I specify which one is to be used? Before I just set the protocol and everything works on wheels... now... its a bit confusing. Having both separated was fine and easy, because I used an .ini file to set parameters and choose the correct .dll Maybe it seems a good idea...

In the 7.3.0-Alpha, the embedded MySQL driver is not present in the protocols list. Is this a new "feature"? EDIT: There are two libraries for MySQL - libmysql.dll (this one works with protocol MySQL and connects to remote servers) - libmysqld.dll (this one is not available, it is supposed...

From what I see, you miss some DLLs, you need to put libmysql.dll in the same folder as your app or put it in a system path. If you don't have any DLL, you must download mysql zip file and have a look inside the lib folder for them (don't mix x32 with x64 binaries). There are 2 DLLs, one for remote ...

That's an issue with SQLite, it only has 4 datatypes and to be worst enough, they are interchangeable and not strict typed.

To be able to connect to a remote server, in the hostname you put it's domain or ip address (also need to set the port), the rest stays as is. The Mysql server must be reachable, that means it must be in the same network space or expossed to the internet (something not so wise imho).

Here's an example of what I do to connect to any database engine supported by ZeosLib fini:= TIniFile.Create(ChangeFileExt( application.ExeName,'.ini')) ; with ZConnection1 do begin Protocol := fini.ReadString('Database', 'Protocol', 'mysqld-5'); Database := fini.ReadString('Database', 'Database', '...

check if you have added ALL the folders from the sources (component, core, dbc, parsesql, plain) to your library path, then try to recompile.

When you download the MySQL Community Server for Windows, in the lib folder you can find both libmysql.dll and libmysqld.dll. But beware, the latest versions of libmysqld.dll don't work, I found that myself and post it in the MySQL section. The one that still works is version 5.6.10. Previous versio...

Some days ago, when updated my local server to latest MySQL binaries (32 bits), the remote conections works fine, but the embed one throwns an Access Violation. This happens with versions 5.6.21 and 5.6.23. Have reverted to version 5.6.10 and everything works fine. Didn't try other versions, neither...

take a look here http://zeoslib.sourceforge.net/viewtopic.php?t=2627
(I kept the old reference for historical purpose http://zeos.firmos.at/viewtopic.php?t=2627)

Hey man, no need to be rude, we are trying to help you. I take some time to run your code and check what's going on. First, next time you want to catch an exception do it line by line, that way you are going to know what happens in every step. Second, take a time to check your code many times, it he...

CONSTRAINT fk_types_recipe1 , ' + ' FOREIGN KEY (recipe_recipeid) , ' + ' REFERENCES recipe (recipeid) , ' + ' ON DELETE NO ACTION , ' + ' ON UPDATE NO ACTION' + Did you notice that? you put some , in the middle of your command, in the wrong places, that's what I think is your trouble from the very...

I just noticed you use a username and a password, be sure your user has all the rights granted to do any of these operations. Delphi has no preference or dislike with sql, you can do anything allowed by the server. Then, if your server forbids something to your user, your going to get that kind of e...

Mate, your trouble lies in the order in which you create each table, take a closer look, you want to set a relation between tables and some not exists yet. You must create your master tables first, then your dependents.