da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: MySQL Problems!

Forum List » AnyDAC » v 1.x General English

hmichael
User

Junior Boarder

Posts: 18

Karma: 0

MySQL Problems!

Posted: 2005/05/14 13:47

Hello,
trying to run the following SQL on anydac Executor (MySQL server):
select * from 'master'

The result will the below:
select * from 'master'
... select * from 'master'
...
ERROR: External exception C000001D

---------------------------------------------
Script finished (0 s).

Any ideas ?

Diman

Admin

Posts: 1478

Karma: 18

RE: MySQL Problems!

Posted: 2005/05/14 14:33

Hello !

MySQL accepts as quoting character [`] and not ['], as you wrote. So, after changing:
select * from 'master'
to
select * from `master`
Executor should work.

But why there is external exception ? Could you, please, answer on following questions:
1) Your MySQL server version ?
2) Your MySQL client (libmysql.dll) version ?

Regards,
Dmitry

Diman

Admin

Posts: 1478

Karma: 18

RE: MySQL Problems!

Posted: 2005/05/14 16:15

I have figured the reason of exception. It is fixed. Thank you for reporting.

Regards,
Dmitry

hmichael
User

Junior Boarder

Posts: 18

Karma: 0

RE: MySQL Problems!

Posted: 2005/05/15 15:21

Hello,
Thanks for pointing out the quote problem. Now using the correct quotes i'm getting the following:

select * from `MASTER`

ERROR: Invalid floating point operation

---------------------------------------------
Script finished (13,375 s).

LibMySQL: 1,01 MB (1.060.864 bytes)
got from -> http://dev.mysql.com/downloads/administrator/1.0.html

Thanks!

Table stracture:

CREATE TABLE `MASTER` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(20) default NULL,
`PICTURE` blob,
`DESCRIPTION` blob,
`CATEGORY` varchar(20) default NULL,
`LINK` blob,
`MANUAL` blob,
PRIMARY KEY (`ID`),
KEY `NAME` (`NAME`),
KEY `CATEGORY` (`CATEGORY`)
) TYPE=MyISAM PACK_KEYS=1 CHECKSUM=1

Diman

Admin

Posts: 1478

Karma: 18

RE: MySQL Problems!

Posted: 2005/05/16 09:21

Hello !

quote:
ERROR: Invalid floating point operation
LibMySQL: 1,01 MB (1.060.864 bytes)
got from -> http://dev.mysql.com/downloads/administrator/1.0.html

It is MySQL v 5.0.1 client. AnyDAC is not tested with this MySQL version. Please, use any pre 5.0 version. AnyDAC v 1.1 will support MySQL 5.0.

Regards,
Dmitry

hmichael
User

Junior Boarder

Posts: 18

Karma: 0

RE: MySQL Problems!

Posted: 2005/05/16 12:36

Hello,
Do you know where i can find the latest MySQLlib.dll for v4

Diman

Admin

Posts: 1478

Karma: 18

RE: MySQL Problems!

Posted: 2005/05/16 12:50

Hello !

quote

o you know where i can find the latest MySQLlib.dll for v4

You can find it there - http://dev.mysql.com/downloads/mysql/4.1.html

PS: I have just finished with implementation of MySQL v 5.0 support.

Regards,
Dmitry

hmichael
User

Junior Boarder

Posts: 18

Karma: 0

RE: MySQL Problems!

Posted: 2005/05/17 07:30

Hello,
That's good news! but i don't have MySQL 5 to test it yet ... Although it's good to have!

So, we can expect a beta soon ?

Thanks!

Diman

Admin

Posts: 1478

Karma: 18

RE: MySQL Problems!

Posted: 2005/05/19 16:31

Hello !

AnyDAC v 1.0.2 will be released at monday.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English