Recent

Author Topic: MySql Ver 5  (Read 11174 times)

thaimann

  • Jr. Member
  • **
  • Posts: 84
MySql Ver 5
« on: November 18, 2007, 05:44:15 am »
Is there any documantation on getting Lazarus working with mysql ver 5?

windy

  • Full Member
  • ***
  • Posts: 186
RE: MySql Ver 5
« Reply #1 on: November 18, 2007, 05:32:36 pm »
what are you wanting to achieve?

piper62

  • New Member
  • *
  • Posts: 41
RE: MySql Ver 5
« Reply #2 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.

thaimann

  • Jr. Member
  • **
  • Posts: 84
MySql Ver 5
« Reply #3 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

windy

  • Full Member
  • ***
  • Posts: 186
MySql Ver 5
« Reply #4 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

thaimann

  • Jr. Member
  • **
  • Posts: 84
MySql Ver 5
« Reply #5 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

windy

  • Full Member
  • ***
  • Posts: 186
MySql Ver 5
« Reply #6 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

Marc

  • Administrator
  • Hero Member
  • *
  • Posts: 2582
MySql Ver 5
« Reply #7 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
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker

bdexterholland

  • Jr. Member
  • **
  • Posts: 65
  • uh?
MySql Ver 5
« Reply #8 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?
[sleep .....]

OnixJr

  • Full Member
  • ***
  • Posts: 172
    • http://www.brlazarus.kit.net
MySql Ver 5
« Reply #9 on: January 11, 2008, 04:38:14 pm »
%windir%\system32 or add the path where is libMySQL.dll to %PATH% environment path...
Portal Lazarus Brasil - http://lazaruspascal.codigolivre.org.br/portal.php
Lazarus BOOK (in portuguese) - http://lazarus-book.blogspot.com
<hipernetjr@yahoo.com.br> - Curitiba/Brazil

OnixJr

  • Full Member
  • ***
  • Posts: 172
    • http://www.brlazarus.kit.net
MySql Ver 5
« Reply #10 on: January 11, 2008, 04:41:30 pm »
* environment variable

=)
Portal Lazarus Brasil - http://lazaruspascal.codigolivre.org.br/portal.php
Lazarus BOOK (in portuguese) - http://lazarus-book.blogspot.com
<hipernetjr@yahoo.com.br> - Curitiba/Brazil

bdexterholland

  • Jr. Member
  • **
  • Posts: 65
  • uh?
MySql Ver 5
« Reply #11 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?
[sleep .....]

ssamayoa

  • Full Member
  • ***
  • Posts: 163
MySql Ver 5
« Reply #12 on: January 19, 2008, 02:30:40 am »
Check if the MySQL Dll doesnt depends on other DLL such MSVC runtime.

McCorder

  • New Member
  • *
  • Posts: 10
MySql Ver 5
« Reply #13 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.

OnixJr

  • Full Member
  • ***
  • Posts: 172
    • http://www.brlazarus.kit.net
MySql Ver 5
« Reply #14 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...
Portal Lazarus Brasil - http://lazaruspascal.codigolivre.org.br/portal.php
Lazarus BOOK (in portuguese) - http://lazarus-book.blogspot.com
<hipernetjr@yahoo.com.br> - Curitiba/Brazil

 

TinyPortal © 2005-2018