Meta data not reporting autoinc correctly

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
aducom
Zeos Dev Team
Zeos Dev Team
Posts: 62
Joined: 30.08.2005, 13:21

Meta data not reporting autoinc correctly

Postby aducom » 03.11.2016, 16:55

I have an issue which is most likely due to a wrong mysql dll. If I use an old dll from 2006 all work quite well, except that the metadata component does not report autoinc fields. I tried to replace the mysqllib from my wamp mysqlpackage (32 bits) but it refuses to load. I wonder what is wrong, I'm using a recent version for wamp the db is version 5.7.44

Anybody has (had) similar problems?

marsupilami
Gold Boarder
Gold Boarder
Posts: 571
Joined: 17.01.2011, 14:17

Re: Meta data not reporting autoinc correctly

Postby marsupilami » 03.11.2016, 21:15

Hello aducom,

I tested this and it seems that with recent Software everything works. I get an auto_increment in the REMARKS column and a true in the AUTO_INCREMENT column of a TZSQLMetaData component.

My test environment:
- MySQL 5.7.11 64 Bits
- MySQL Connector/C 6.1.6 32 Bits
- ZeosLib 7.2 from SVN
- Delphi 2010

Which results do you get? Which Zeos version do you use? Do you get different results if you download the current MySQL Connector/C and specify its libmysql.dll in the library location property?

With best regards,

Jan

aducom
Zeos Dev Team
Zeos Dev Team
Posts: 62
Joined: 30.08.2005, 13:21

Re: Meta data not reporting autoinc correctly

Postby aducom » 03.11.2016, 21:22

Tnx Jan. I have 64bits wamp but since Lazarus runs 32bits I use the 32 bits dll. I was not complete in my question appearantly as I'm not using Delphi (any more) but lazarus. However. Since it's working with you it's something in finding the right dll I guess. The dll from 32 bits mysql generates a load error. Will try to dive into this.
Albert

aducom
Zeos Dev Team
Zeos Dev Team
Posts: 62
Joined: 30.08.2005, 13:21

Re: Meta data not reporting autoinc correctly

Postby aducom » 03.11.2016, 22:03

Yep, found it. Replacing the dll did the job. Tnx again.


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest