libmysql.dll Problem

[TheOddOne]

I'm running a Windows 7 OS, 64 bit system with lazarus 1.2.6

I'm sorry to this but WHY is connecting to a database so hard. I've been trying for days to get my program linked with my online database. It's been having problems with finding two annoying, disgusting and vile files ( libmysql.dll and dbilib.dll ). I've tried sticking them everywhere lol, literally. System32, SystemWow32, Lazarus, the program directory and various other places. Although still saying it can't be found. Where are these files suppppposed to be located?

[skalogryz]

maybe files can be found, but these are wrong versions of files?

[mirce.vladimirov]

I'm running a Windows 7 OS, 64 bit system with lazarus 1.2.6
...
 Where are these files suppppposed to be located?

I'm using MySQL 5.0, i develop my application on Win7 32 bit with Lazarus 32bit but it runs on XP, Vista, w7, w8 some are 32 and some are 64 bit.
Always copy libmysql.dll to c:/windows/system  and that's it. Works. Period.

[TheOddOne]

Hmm, just tried that directory and got the same message. Here a screenshot too:

http://i.imgur.com/JU96FHp.png

When I change the connector to say MSSYQL, it then it can't find dbilib.dll.

[sam707]

im using 64bits MySQL server and developping a 32bits application with NO PROBLEM, i did just put libmysql.dll (32bits version) in 2 places 1) in lazarus bin folder 2) in my app target bin folder

MySQL do not care if commands come from 16bits, 32bits, 64bits etc programs as it uses Tcp/Ip (or pipes) to communicate with programs. Connections are Alike!

[TheOddOne]

Where is the lazarus bin folder located? I can't find it in the directory.

[mangakissa]

normally c:\lazarus

[TheOddOne]

Hmm. I'll literally pay anyone $10 to come on teamviewer with me and help me sort this very small problem.

[sam707]

1) find the folder where reside lazarus.exe
2) copy the dll here to be able to use mysql inside the IDE
3) copy that same dll in the folder where you compile your application, that is needed at standalone runtime

thats it!!!

[TheOddOne]

I did that 5 times repeating myself for sure and still displays the same message.

[exdatis]

See:
http://forum.lazarus.freepascal.org/index.php/topic,26148.msg161010.html#msg161010