Forum > Databases
something wrong here, and i don't know where
Guess:
Got a little "fatal" error here
I Install
- free pascal ver 2.0.0.i386-win32
- Lazarus ver 0.9.10-20051002-win32
- file libmysql.dll from Mysql 4.0.26
I get this error message after install package mysql4laz.lpk
"The Procedure entry point mysql_server_init could not be located in the dinamic library libmysql.dll"
and now i can't get into Lazarus anymore unless i uninstall and then reinstall it.
as information
I use it on
win XP sp2
on AtlhonXP 1700+
512MB DDR
GFX 5200
ECS Elite MB N2U-400A
80 GB Seagate HD
Any Idea how to handle it?
Or at least tell me whict version of lazarus "Runs" that mysql-package on my system
Please!!!!
Thanks before
By the way
does Anyone know if lazarus has component to create any data report? Or to connect to a data report program such as crystal report (or any other good suggestion)?
felipemdc:
There is nothing wrong there. If you install a package witch requires an external library, then you need to install that library.
You can download mysql here: http://www.mysql.com/
If mysql is installed and you still get the error message, locate libmysql.dll on your computer and put it on your Lazarus folder, or make sure there is a link to the place where the dll is on the PATH environment variable.
Marc:
@sekel, he wrote that he has a libmysql.
the error
--- Quote ---The Procedure entry point mysql_server_init could not be located in the dinamic library libmysql.dll
--- End quote ---
means that the dll is found, but a required function wasnt found inside the dll.
@guest
I think the package is maybe outdated. Maybe you can try sqldb, it also supports mysql 4, 4.1 and 5.
Anonymous:
Thank you for the fast reply.
Installing sqldb give me the
tmysqlconnection and all others which i should need to connect to mysql
therefore i follow the tutorial on connecting to mysql from the wiki
then...
i got this error
Project raised exception class 'EDatabaseError' with message:
MySQLConnection1 : Server connect failed
i know that means i can't connect to mysql
i use
user : root
passwort : blank (no password)
host : localhost
i'm pretty sure there's nothing wrong with my code (i was once making programs with delphi, a long time ago)
(i'm following the tutorial and make it simpler, "i only try to fill a text box with some string if a connection is established")
do you knows how to handle this?
or are there any tutorial or example sourcecode using sqldb Tmysqlconnection to connect to some database?
Thanks you before
Anonymous:
Sorry, perhaps i was't very informative yesterday
here are things i did to produce the error =)
i drag 1 mysqlconnection (the blue dolphin) to my form
then at form_create i write :
MySQLConnection1.UserName:='root';
MySQLConnection1.Password:='root';
MySQLConnection1.HostName:='localhost';
MySQLConnection1.Open;
i get error message :
project raised exception class 'EDatabaseError' with message:
MySQLConnection1 : Server connect failed
is there any mistakes in my code?
It compiles but that error message shows when running
and after that
lazarus shows a window titled "file not found"
the file "db.pp" was not found
do you want to locate it yourself ?"
Then i change the "compiler option" at project menu
adding path "Other Unit Files" to lazarus\fpcsrc\fcl\db
and lazarus\fpcsrc\fcl\win32
it gives me the same message, but now window db.pp is open and give me this line :
Raise EDatabaseError.CreateFmt('%s : %s',[Comp.Name,Msg]);
with lots of lines in message window looks like :
db.pp(8,44) Hint: File c:\Lazarus\fpcsrc\fcl\db\something.inc is newer than Release PPU file c:\lazarus\pp\units\i386-win32\fcl\db.ppu
Any idea what happens here and how to handle this?
by the way,
i get this error message after I copy the libmysql.dll to
windows/system32 directory
if i copy that file to lazarus directory, it can't find the dll
I change my MySQL version to 5.0 (because i read your reply, it says sqldb can connect to ver 5.0),
yet still use the lib from MySQL 4.0 (since it gives error message if i use the lib from ver 5.0)
Navigation
[0] Message Index
[#] Next page