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

sdowney717 · Mar 18, 2024

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

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.

sdowney717 · Mar 18, 2024

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.

sdowney717 · Mar 18, 2024

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)"

sdowney717 · Mar 18, 2024

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]>

sdowney717 · Mar 18, 2024

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

sdowney717 · Mar 19, 2024

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.

[ODBC-418] when encrypting string using my function, table columns updates fail - Jira

jira.mariadb.org

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

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

[ODBC-418] when encrypting string using my function, table columns updates fail - Jira

My Computer

System One

Similar threads

Latest Support Threads

Latest Tutorials