Page 1 of 1

Meta data not reporting autoinc correctly

Posted: 03.11.2016, 16:55
by aducom
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?

Re: Meta data not reporting autoinc correctly

Posted: 03.11.2016, 21:15
by marsupilami
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

Re: Meta data not reporting autoinc correctly

Posted: 03.11.2016, 21:22
by aducom
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

Re: Meta data not reporting autoinc correctly

Posted: 03.11.2016, 22:03
by aducom
Yep, found it. Replacing the dll did the job. Tnx again.