da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: MySQL 5.0.41(?) + AnyDAC 1.11.0(?) + D7 = T_T

Forum List » AnyDAC » v 1.x General English

NOSTOC
User

Fresh Boarder

Posts: 2

Karma: 0

MySQL 5.0.41(?) + AnyDAC 1.11.0(?) + D7 = T_T

Posted: 2007/09/10 13:28

Hi, I'm planning to use AnyDAC for my new small project (POS). But I've problem when I connect Delphi 7 to MySQL 5.0.41(?).

AnyDAC says it needs mysqllib.dll in application path or "PATH" path. I've copied mysqllib.dll from MySQL directory to system32, delphi projects dir, C: but it doesn't work.
Why? Did I make a mistake?

When I try to connect it via ODBC (MyODBC 3.51) it works (but not know about speed - slow?) except for SP. I wrote one SP that has 2 resultset like this :
CREATE PROCEDURE a()
BEGIN
SELECT 1;
SELECT 2;
END;

I used TADQuery ('Call a();'), why AnyDAC just show me 1 resultset ?
With Ms SQL Server 2K it works good.

Sorry for bad english...

Niksen

Diman

Admin

Posts: 1495

Karma: 19

Re:MySQL 5.0.41(?) + AnyDAC 1.11.0(?) + D7 = T_T

Posted: 2007/09/10 23:21

Hello

1) What is exact text of error you are getting ? In general, I will suggest to search for all libmysql.dll copies in your PATH directories and remove all extra. Then put libmysql.dll into system32.

2) I am not sure, but MySQL ODBC driver is very limited in capabilities. So, if it does not support multiple result sets, then AnyDAC will not support too. Anyway, AnyDAC native MySQL driver is more stable, fast and feature reach, than to work through ODBC.

PS: I have checked your example and it works well on my PC.

Regards,
Dmitry

NOSTOC
User

Fresh Boarder

Posts: 2

Karma: 0

Re:MySQL 5.0.41(?) + AnyDAC 1.11.0(?) + D7 = T_T

Posted: 2007/09/11 00:29

Thank you very much for your advice...

1. AnyDAC said that mysqllib.dll cannot be found, and I must place it in project directory or PATH directory.

2. For many times I used MyODBC + MySQL 4.0.17 and they work fine for me. But with MySQL 5 (with SP)

It works well in your PC ?

Well, I will try it again...

Thank you...

Sorry... Not mysqllib.dll but libmySQL.dll

Sorry for bad english...

Niksen

Post edited by: NOSTOC, at: 2007/09/12 11:34

Forum List » AnyDAC » v 1.x General English