Recent

Author Topic: something wrong here, and i don't know where  (Read 7728 times)

Guess

  • Guest
something wrong here, and i don't know where
« on: December 26, 2005, 05:19:44 pm »
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

  • Administrator
  • Hero Member
  • *
  • Posts: 3538
RE: something wrong here, and i don
« Reply #1 on: December 26, 2005, 06:12:32 pm »
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

  • Administrator
  • Hero Member
  • *
  • Posts: 2590
RE: something wrong here, and i don
« Reply #2 on: December 27, 2005, 11:31:18 am »
@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
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.
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker

Anonymous

  • Guest
RE: something wrong here, and i don
« Reply #3 on: December 28, 2005, 04:07:40 pm »
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

  • Guest
RE: something wrong here, and i don
« Reply #4 on: December 29, 2005, 04:02:48 pm »
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)

JanH

  • Guest
RE: something wrong here, and i don
« Reply #5 on: January 02, 2006, 12:47:12 pm »
If lazarus after a package-install craches, you can undo the package-install by:
- deleting the lazarus.exe and rename the backup file (lazarus.old.exe).
- after starting old lazarus go to the installed packages-dialog and remove the package wich the error has raised
- recompile

its easier the reinstall lazarus again ;-)

 

TinyPortal © 2005-2018