What you don' like be-in haxored?

lol

Make sure that you cannot login into mysql without password. This is very important.

Regards,

Yoyong

Internet Mail Message
Received from host:
svcr-216-37-230-2.dsl.svcr.epix.net
[216.37.230.2]

From: SteveG on 04/16/2003 06:51 AM GMT

SteveG To: Lazarus Mailing List

Cc: (bcc: Yoyong Hernan-ET/PGI)
Subject: [lazarus] Using SQL Object
04/16/2003 02:51 PM
Please respond to

Could someone pls tell me whats wrong with the following code ? I found it on a post on the fpc site (somebody else having this error about 2 yrs ago) and decided to use as my 'learner' - still has errors

I am using latest cvs of lazarus and rpm's of fpc from laz downloads The test database exists and data is in FPdev - works ok from shell

procedure tform1.button1click(sender: tobject);
var
   Data : TMysqldataset;
begin
   Data:=TMysqlDataset.Create(nil);
   With Data do begin
     Host:='localhost';
     Database:='test';
     User:='root';
     PassWord := '******';
     SQL.text := 'select * from FPdev';
     Open;//Here an error "Internal error." occurs
     Close;
     Free;
   end;//with Data do
end;

suggestions much appreciated

_________________________________________________________________ To unsubscribe: mail with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives

Could someone pls tell me whats wrong with the following code ? I found it on a post on the fpc site (somebody else having this error about 2 yrs ago) and decided to use as my 'learner' - still has errors

I am using latest cvs of lazarus and rpm's of fpc from laz downloads The test database exists and data is in FPdev - works ok from shell

procedure tform1.button1click(sender: tobject);
var
   Data : TMysqldataset;
begin
   Data:=TMysqlDataset.Create(nil);
   With Data do begin
     Host:='localhost';
     Database:='test';
     User:='root';
     PassWord := '******';
     SQL.text := 'select * from FPdev';
     Open;//Here an error "Internal error." occurs
     Close;
     Free;
   end;//with Data do
end;

suggestions much appreciated

- What client library version are you using ?
- What is the version reported by the mysql_version unit ? They should match.

Michael.

Code remains the same as below, the difference is that it now fails on the close cmd instead of the open

I have installed Mysql server version 3.23.52

The part that could be causing the problem is libmysqlclient.so (where should I have got this from ?) Found my current copy searching on the Net, so may not be correct for this setup (how to tell ?)

Kindly elaborate what is the problem, I think it is also wise if you can send us the code.

Yoyong

Internet Mail Message
Received from host:
svcr-216-37-230-2.dsl.svcr.epix.net
[216.37.230.2]

From: SteveG on 04/27/2003 01:42 PM GMT

SteveG To:
Cc: (bcc: Yoyong Hernan-ET/PGI)
Subject: Re: [lazarus] Using SQL Object

04/27/2003 09:42 PM
Please respond to

That seems to have cleared the problem with opening a database - Thanks

Now code fails at the Close command - as long as I dont use the close (ie just quit the program once done) all works ok (not good, but at least it works)

I run into the same problem before, it was access violation error. And my solution was to remove all users of the mysql database without password. Such that when you log into mysql console like mysql -u root -h

myhost.test.com

-p you will need to enter password. And also check that merely entering mysql

at

_________________________________________________________________ To unsubscribe: mail with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives

Is it possible the mysql-devel package doesn't match the version of mysql you are running?

I run into the same problem before, it was access violation error. And my solution was to remove all users of the mysql database without password. Such that when you log into mysql console like mysql -u root -h myhost.test.com -p you will need to enter password. And also check that merely entering mysql at the console will not allow you to log in.

If this still fails for you, please let me know.

Regards,

Yoyong

Internet Mail Message
Received from host:
svcr-216-37-230-2.dsl.svcr.epix.net
[216.37.230.2]

From: SteveG on 04/16/2003 07:55 PM GMT

SteveG To:
Cc: (bcc: Yoyong Hernan-ET/PGI)
Subject: Re: [lazarus] Using SQL Object

04/17/2003 03:55 AM
Please respond to

Yoyong - do you mean that the sql code wont work if the database has no password ?

If my test code is way off track, could you point me to something that works using the sql object within lazarus ?

_________________________________________________________________ To unsubscribe: mail with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives

Yoyong - do you mean that the sql code wont work if the database has no password ?

If my test code is way off track, could you point me to something that works using the sql object within lazarus ?

That seems to have cleared the problem with opening a database - Thanks

Now code fails at the Close command - as long as I dont use the close (ie just quit the program once done) all works ok (not good, but at least it works)