Lazarus

Programming => Databases => Topic started by: thaimann on November 18, 2007, 05:44:15 am

Title: MySql Ver 5
Post by: thaimann on November 18, 2007, 05:44:15 am

Is there any documantation on getting Lazarus working with mysql ver 5?

Title: RE: MySql Ver 5
Post by: windy on November 18, 2007, 05:32:36 pm

what are you wanting to achieve?

Title: RE: MySql Ver 5
Post by: piper62 on November 21, 2007, 02:17:14 am

We tested Lazarus with the SQL-DB components and ZeosLib. Both are working with MySQL Ver. 5.

Title: MySql Ver 5
Post by: thaimann on November 26, 2007, 12:46:13 am

I haven't been able to connect to my MySQL 5.0 server.  I get tthe following message when I try to connect:

"Can not load MySQL library libmysqlclient.so. Please check installation."

I have tried putting links where the old MySQL 4.x documentation recommended, but it doesn't seem to be working.  I am running fc 7.

Terry

Title: MySql Ver 5
Post by: windy on November 26, 2007, 01:52:42 am

do you have mysql installed?
(so that you then get the libmysqlclient.so file)
what you mind find is that you need to do a symbolic link change from the number libmysqlclient.so file
or do I as did, just rename the numbered one (i.e with numbers on the end) to libmysqlclient.so
and also make sure that file is in /usr/lib/ and /sw/lib/
too

Title: MySql Ver 5
Post by: thaimann on November 26, 2007, 03:33:59 am

When I do a locate, I get::

/home/myuser/MyDocuments/fpc/AstroRpt/libmysqlclient.so
/home/myuser/MyDocuments/fpc/NameSys/libmysqlclient.so.14
/home/myuser/bin/libmysqlclient.so
/usr/lib/lazarus/libmysqlclient.so
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0

Title: MySql Ver 5
Post by: windy on November 26, 2007, 04:32:38 am

try copying the libmysqlclient.so to the /usr/lib/
and if you have it
/sw/lib/
and also /sw/bin/ folders
and also where you have your program

Title: MySql Ver 5
Post by: Marc on November 26, 2007, 11:03:30 am

Have a look at this thread:
http://www.lazarus.freepascal.org/index.php?name=PNphpBB2&file=viewtopic&t=3548

also note that *.so.14 is for mysql4 and *.so.15 is for mysql5

Title: MySql Ver 5
Post by: bdexterholland on January 11, 2008, 02:55:35 pm

Well, I'm trying on Windows and my lazarus can't find libMySQL.dll. Someone knows where can i place this DLL?

Title: MySql Ver 5
Post by: OnixJr on January 11, 2008, 04:38:14 pm

%windir%\system32 or add the path where is libMySQL.dll to %PATH% environment path...

Title: MySql Ver 5
Post by: OnixJr on January 11, 2008, 04:41:30 pm

* environment variable

=)

Title: MySql Ver 5
Post by: bdexterholland on January 12, 2008, 09:28:59 pm

i've tryed it and tryed in other folders. Any hint?

Onix, eu tô pensando em fazer uma webpage br para lazarus, postar componentes, tuto e tal, o que acha?

Title: MySql Ver 5
Post by: ssamayoa on January 19, 2008, 02:30:40 am

Check if the MySQL Dll doesnt depends on other DLL such MSVC runtime.

Title: MySql Ver 5
Post by: McCorder on January 21, 2008, 05:17:45 pm

Quote from: "bdexterholland"

i've tryed it and tryed in other folders. Any hint?

I just tried this and the only way I got it to work was to add the path from the MySql\bin folder to the system PATH variable which is set by right-clicking the My Computer icon, selecting properties etc.etc.

If you have copied libmysql.dll somewhere else (e.g. system32 or where your app is located) you will need to delete them as it will pick up this one and not any other dlls it depends on.

Title: MySql Ver 5
Post by: OnixJr on January 24, 2008, 11:02:47 pm

Quote

Onix, eu tô pensando em fazer uma webpage br para lazarus, postar componentes, tuto e tal, o que acha?

Please, send me a private message when you are online.... or add-me in MSN...