Solved yesterday I installed mysql 8.0.36 fine, I uninstalled it using its uninstaller, install today fails with error

jimbo45 said:

You don't need to change anything -- assuming you were using MySQL rather than the Ms SQL server

For example (type either mariadb or mysql on the command line).

Identical on Windows too !!!

I'd give it a shot. Try it on a Windows VM first if you are a bit dubious.

View attachment 90060

cheers
jimbo

Click to expand...

Well, I download latest MariaDB and the ODBC connector, logged into it with my app and created the database, which I need to see if that fully worked.
Then I went to add a record, that worked.

But did a search and got an error. So the sql statements are not fully compatible.
As I said, It would require some reprogramming and maybe a fair amount.
Which is a little odd, but it is showing it here.

yup, that is the problem the table creation statements are incompatible, It looks like as the table does not exist and it should have been created when I created the database.

this table creation statement works fine in MySQL but not for MariaDB
Anyone familiar enough with MariaDB to say why it does not work?

frmLogon.cnConnector.Execute "DROP TABLE IF EXISTS titledata"
frmLogon.cnConnector.Execute "CREATE TABLE IF NOT EXISTS titledata" & _
"(Id INT AUTO_INCREMENT PRIMARY KEY," & _
"NumId INT DEFAULT 0 ) ENGINE = INNODB"
frmLogon.cnConnector.Execute "CREATE INDEX IdIndex ON titledata(Id)"

mariadb does create table by hand, so can look further into why it is not doing it.

MariaDB [books]> create table titledata (Id INT AUTO_INCREMENT PRIMARY KEY, NumID INT DEFAULT 0);
Query OK, 0 rows affected (0.012 sec)

MariaDB [books]>

well. I think issue is I set this program up for mysql or MS sqlserver and if I login as mysql I do certain if statements. And since it is mariadb, it does not know exactly what to do, so it thinks it is MS SQL Server. Reason is Mysql and SQL Server have slightly different syntax., so that ables do not created properly

Yes, that was it. I did a few changes, and the MariaDB works fine. It feels a little quicker to me than Mysql.
What does NOT work is their ODBC 3.1 32 bit driver, it is a total dud with my program.

The Mysql 8.0 driver, both ANSI and UNICODE 32 bit driver works great with my program.
A fellow on a MariaDB forum said to file a bug report so I did.