Help connect zeos to embedded mysql server

adi3000 · Post by **adi3000** » 25.08.2005, 09:45

Can enyone help me using mysql embedded server from zeos ?

fduenas · Post by **fduenas** » 26.08.2005, 08:37

embedded server is not already full implemented. have you tried to rename libmysqle.dll to libmysql41.dll?

zippo · Post by **zippo** » 20.10.2005, 18:27

So, It worked? I'm curious....

nuker · Post by **nuker** » 04.03.2006, 18:29

i rename libmysqld.dll to libmysql41.dll and get AV

zippo · Post by **zippo** » 04.03.2006, 19:37

First you have to initialize the DLL. H've done it sometime ago, but had problems on application exit.. (AV)..

nuker · Post by **nuker** » 04.03.2006, 23:27

zippo wrote:First you have to initialize the DLL

LoadLibrary(); ?

zippo · Post by **zippo** » 05.03.2006, 09:29

No, the DLL has some special functions you must calll from the app. So far it worked on initialize, but I can't make the finalization, just before closing the application.

I've atached the small test code, so you can study it.. Enjoy!

nuker · Post by **nuker** » 05.03.2006, 13:39

So, look at this components:
http://www.scibit.com/products/mysqlcomponents/
it's really support (embedded,Direct,Client) MySQL 3 - 5

casanova_frank · Post by **casanova_frank** » 06.06.2006, 16:33

zippo wrote:No, the DLL has some special functions you must calll from the app. So far it worked on initialize, but I can't make the finalization, just before closing the application.

I've atached the small test code, so you can study it.. Enjoy!

I am interested on tring this. Can you send me that test code you mention here. It seems that it was deleted from your post.

Thanks in advance.

Post by **mdaems** » 06.06.2006, 18:33

Were you logged in while looking for the download? For me downloading works nice.
Did not try to use it, however.

Can somebody tell me where I can find a recent libmysqld.dll. I did not find it in recent 5.0 and 5.1 distributions.

Mark

aebi · Post by **aebi** » 26.06.2006, 07:45

Maybe my problem ist something different, maybe it has the same reason : I'm using PopstgreSQL with Zeos 6.5.1 (alpha) and Delphi 7. Using TZConnection in main programm works fine, also in static DLLs ("xy external bla.dll"). When I load a DLL via "LoadLibrary" / "GetProcAddress" and create the TZConnection in the DLL i get AV in the main programm after the DLL is unloaded. I'm not very familar with Zeos at the moment, so perhaps there are some more steps for initialization ?

Andreas

fduenas · Post by **fduenas** » 27.06.2006, 00:25

Hi a new revision of ZeosDBO has been posted a long time go. It supports new mysql5 and mysqld5 (embedded) give ti a try and tell us your esxperience. by default all data has to be in a 'data' subdirectory of the folder where the executable is. yoiu can change this option using a my.ini file. Checl Mysql embedded server help for more info.

You can download latest SVN revisions from here: http://users.telenet.be/mdaems/

casanova_frank · Post by **casanova_frank** » 27.06.2006, 22:11

mdaems wrote:Were you logged in while looking for the download? For me downloading works nice.
Did not try to use it, however.

Can somebody tell me where I can find a recent libmysqld.dll. I did not find it in recent 5.0 and 5.1 distributions.

Mark

Finally I could download it. Don´t know why before the link didn´t appeared.

Now I´ll give it a try.

Questions: Have you found that DLL you where looking for? Can´t you compile it from source?

I have compiled once libmysql.dll (not exactly what you're looking for) from source for tring UDF with MySQL under Win32. Think the same process can help to obtain the DLL you need.

Post by **mdaems** » 27.06.2006, 22:39

Hi,

I haven't found the dll but we've tried to do the job using the 4.1 version. There it seems to work, so just go on and give it a try with the most recent package I've distilled. (see link above)

Compiling mysql myself would be a hell of a job for me as I even don't know where to start. As I'm not an 'embedded' user myself, I'm not really thinking about it. If somebody has a Dll, he can always share it with us.

Mark

Terence · Post by **Terence** » 28.06.2006, 12:31

In my Mysql 5 distribution there is a "libmySQL.dll" included in bin directory,
so why not in yours?
Maybe you disabled some options on intstall, i can't remember which, but i would try a full intstallation.

Anyway i would commit to lib/ in testing branch but still have no svn write access

Btw it would be nice to have libs in zeos package for all supported dbms, still there are only mysql and postgres, any problems with rights else?