Quote from
dglojnar on August 7, 2025, 3:54 pm
So, I have a relly strange problem:
I'm using NeoDBPro with MariaDB/MySQL without problems, working with tables, grids, export etc...everything working fine.
But....!
When I try to create a report using Report Designer, there is no data on the report although the SQL Query was executed correctly and displayed correctly as a result in the table (correct record number, all data matches)
With SQLite and other databases no problem at all, only with MariaDB/MySQL.
Now my question is - what could be the problem?
Does the connection string have an impact on the report?
Because with the existing connection string everything works OK, all SQL Queries, even very complex ones, searching, sorting, exporting - everything except the report..
Is it maybe a problem with MariaDB/MySQL or something else?
Also, please note I'm using XAMPP 8.0.30 as local Server and MariaDB/MySQL from same installation:
- Server-Version: 10.4.32-MariaDB - mariadb.org binary distribution
- Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
- Datenbank-Client Version: libmysql - mysqlnd 8.2.12
- phpMyAdmin 5.2.2 and XAMPP Control Panel 3.3.0
Maybe is problem with MariaDB ?
Has anyone had a similar problem or maybe has a suggestion?
Thanks in advance!
Cheers!
So, I have a relly strange problem:
I'm using NeoDBPro with MariaDB/MySQL without problems, working with tables, grids, export etc...everything working fine.
But....!
When I try to create a report using Report Designer, there is no data on the report although the SQL Query was executed correctly and displayed correctly as a result in the table (correct record number, all data matches)
With SQLite and other databases no problem at all, only with MariaDB/MySQL.
Now my question is - what could be the problem?
Does the connection string have an impact on the report?
Because with the existing connection string everything works OK, all SQL Queries, even very complex ones, searching, sorting, exporting - everything except the report..
Is it maybe a problem with MariaDB/MySQL or something else?
Also, please note I'm using XAMPP 8.0.30 as local Server and MariaDB/MySQL from same installation:
- Server-Version: 10.4.32-MariaDB - mariadb.org binary distribution
- Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
- Datenbank-Client Version: libmysql - mysqlnd 8.2.12
- phpMyAdmin 5.2.2 and XAMPP Control Panel 3.3.0
Maybe is problem with MariaDB ?
Has anyone had a similar problem or maybe has a suggestion?
Thanks in advance!
Cheers!