Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2024-08

Mysql version

4 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Larry Dalton

I am running Lazarus 3.2 on Windows 11.
I am using MySql version 8.0.39.
I am using a single form test program, with only one unit. My components are:
InventoryConnection = TMysql80Connection
InventoryQuery = TSqlQuery with InventoryConnection as database InventorySource =Tdatasource with InventoryQuery as dataset InventoryTransaction = TSQLTransaction with InventoryConnection as Database InventoryGrid =TDBGrid with InventorySource as datasource

The test database is inventory with one table named 'base_info';
table has two columns: ID = INT and Stock_num =varchar(10);

when I set connection on connected property on InventoryConnection to TRUE and set Active property on InventoryQuery to True in design time, everything connects and opens just fine, and the columns appear in InventoryGrid,

However, when I run the application, I get the following error: 'TMySql80Connection can not work the the installed MySQL client erosion: Expected (8.0), got (6.1.10), and the application aborts.

I added a TMySql57connection to the same database on the same form, and got the reverse error, expected (5.7), got (8.0.39).

help, please
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20240815/3c863be0/attachment.htm>

Reply by email

Goran Atanasijevic
to Larry Dalton

Hi,

you can use workaround

InventoryConnection.SkipLibraryVersionCheck:=true;

I did that when Lazarus didn't read correctly MySQL 5.5 with matching dll version.

Best,
Goran

On Thursday, 15 August 2024 at 06:25:51 pm GMT+2, Larry Dalton via lazarus wrote:

I am running Lazarus 3.2 on Windows 11.?I am using MySql version 8.0.39.?I am using a single form test program, with only one unit.?My components are:InventoryConnection = TMysql80ConnectionInventoryQuery = TSqlQuery with InventoryConnection as databaseInventorySource =Tdatasource with InventoryQuery as datasetInventoryTransaction = TSQLTransaction with InventoryConnection as DatabaseInventoryGrid =TDBGrid with InventorySource as datasource The test database is inventory with one table named 'base_info';table has two columns: ID = INT and Stock_num =varchar(10); when I set connection on connected property on InventoryConnection to TRUEand set Active property on InventoryQuery to True in design time, everything connects and opens just fine, and the columns appear in InventoryGrid,? However, when I run the application, I get the following error: 'TMySql80Connection can not work the the installed MySQL client erosion: Expected (8.0), got (6.1.10), and the application aborts.? I added a TMySql57connection to the same database on the same form,?and got the reverse error, expected (5.7), got (8.0.39).? help, please--

Reply by email

Larry Dalton
to Goran Atanasijevic

When I do that, everything works at design time, but then I get runtime error ?Server connect failed?

On Thu, Aug 15, 2024 at 14:58 Goran Atanasijevic via lazarus <

Show quoted text 56 lines
wrote: Hi, you can use workaround InventoryConnection.SkipLibraryVersionCheck:=true; I did that when Lazarus didn't read correctly MySQL 5.5 with matching dll version. Best, Goran On Thursday, 15 August 2024 at 06:25:51 pm GMT+2, Larry Dalton via lazarus wrote: I am running Lazarus 3.2 on Windows 11. I am using MySql version 8.0.39. I am using a single form test program, with only one unit. My components are: InventoryConnection = TMysql80Connection InventoryQuery = TSqlQuery with InventoryConnection as database InventorySource =Tdatasource with InventoryQuery as dataset InventoryTransaction = TSQLTransaction with InventoryConnection as Database InventoryGrid =TDBGrid with InventorySource as datasource The test database is inventory with one table named 'base_info'; table has two columns: ID = INT and Stock_num =varchar(10); when I set connection on connected property on InventoryConnection to TRUE and set Active property on InventoryQuery to True in design time, everything connects and opens just fine, and the columns appear in InventoryGrid, However, when I run the application, I get the following error: 'TMySql80Connection can not work the the installed MySQL client erosion: Expected (8.0), got (6.1.10), and the application aborts. I added a TMySql57connection to the same database on the same form, and got the reverse error, expected (5.7), got (8.0.39). help, please -- _______________________________________________ lazarus mailing list https://lists.lazarus-ide.org/listinfo/lazarus -- _______________________________________________ lazarus mailing list https://lists.lazarus-ide.org/listinfo/lazarus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20240815/cbb9f496/attachment.htm>

Reply by email

Michael Van Canneyt
to Larry Dalton: I am running Lazarus 3.2 on Windows 11. I am using MySql version 8.0.39. I am using a…
Larry Dalton wrote 21 lines
I am running Lazarus 3.2 on Windows 11. I am using MySql version 8.0.39. I am using a single form test program, with only one unit. My components are: InventoryConnection = TMysql80Connection InventoryQuery = TSqlQuery with InventoryConnection as database InventorySource =Tdatasource with InventoryQuery as dataset InventoryTransaction = TSQLTransaction with InventoryConnection as Database InventoryGrid =TDBGrid with InventorySource as datasource The test database is inventory with one table named 'base_info'; table has two columns: ID = INT and Stock_num =varchar(10); when I set connection on connected property on InventoryConnection to TRUE and set Active property on InventoryQuery to True in design time, everything connects and opens just fine, and the columns appear in InventoryGrid, However, when I run the application, I get the following error: 'TMySql80Connection can not work the the installed MySQL client erosion: Expected (8.0), got (6.1.10), and the application aborts.

if it reports 6.1.10, it means there is a client library 6.1.10 installed somewhere and it gets used before the 8.0 one.

I made some applications that connect with 8.0, I can't remember doing anything special, so it's the most likely cause that there is an old lib lying around?

Michael.

Reply by email