Connect to Mysql

[Nokao]

On an article i read that lazarus still don't support mysql connection, that's intend as VISUAL mysql components or there is no way to to connect to mysql?

Or the article was old?

If it's possible can you give me some links on how?

[matthijs]

Did you have a look at the wiki? This is a very good tutorial.

[Nokao]

Thank you, i was just looking at the lazarus wiki, there is a really huge documentation of a lot of things.

Really a "step ahead" compared to delphi's documentation.

Good demostration of the potentiality of free software.

[Nokao]

Hi, i'm following the guide but i'm getting this error:
C:\apps\lazarus\components\sqldb\registersqldb.pas(33,3) Fatal: Can't find unit mysql40conn

Like if the component is not correctly installed or linked...

Another problem is that if, from lazarus, i set the connection i'm creating to active, i get the error:
could not load the library "libmysql.dll". Please check your installation

Can someone help?

[Vincent Snijders]

Do you have libmysql.dll on your computer? Is it in a directory that is in the PATH environment variable?

Do you have a mysql40conn.ppu on your computer?

[Nokao]

I just installed php5 but i still have the problem, where i can find that dll? Where i have to put it to make it work?

About the LAZARUS problem (the first i showed) i think i'm in a big problem... the sqldblaz.ppu don't exist, compiled for the ARK that i'm compiling with (WinCE-ARM).

[Vincent Snijders]

You have the download the dll from mysql. But I don't know if MYSQL has client libs for arm-wince.

[Nokao]

But the client libs should be for win32, cause i'm only cross-compiling for wince but i get that error using lazarus on my WindowsXP (win32) client.

Am I wrong?

[Vincent Snijders]

No, if you want to use mysql on arm-wince, you need to use the client libs for arm-wince.

If you want to run the application on windows xp, then you can use the win32 client libs.

[Nokao]

Are you sure...? I get the same error with lazarus on win32 compiling...

I'm talking about:
Inside lazarus
Trying to connect to a mysqldb using it's components
Getting an error

Nothing about wince in that i'm doing... (in that second problem)

Wince is mentioned in the first problem...

[Vincent Snijders]

OK. Let's tackle win32 first.

Where did you install the libmysql.dll?

[Nokao]

There is that file in 3 places, all in:

C:\mysql\

Now where do i have to set the paths inside lazarus?

[Vincent Snijders]

Add c:\mysql to the PATH environment variable. Or copy the dll to a directory already in the PATH envrionment variable, like c:\windows\system32.

[Nokao]

Ok now it give me a version error, i'm providing to download 4.1 mysql client libs myself. Thanks for the help.

But for the first, harder, problem? I'm fucked didn't I?

[Vincent Snijders]

But for the first, harder, problem? I'm fucked didn't I?

Using the component on arm-wince? I don't know. Fixing compilation is probably easy. But I doubt it is useful, if there are no client libs from MySql. You need to find out that for yourself first. Then we can change the fpc distribution, if necessary.