MariaDB ODBC settings

[Guillaume]

Hi,

We use a MariaDB to store an EA project. Where MySQL ODBC driver works ok, I was wondering if anyone had tested the MariaDB ODBC driver.
I ran a simple test and I'm getting an Invalid Data Source... Check configuration error.

Any recommandation from Sparx?

thanks

[qwerty]

It should basically be the same as for MySQL. I haven't combined MariaDB with EA so far (just in other configs).

q.

[Eve]

Is there any particular reason why you want to use the MariaDB ODBC driver? EA won't load a model from an ODBC driver it doesn't know about, and we haven't added MariaDB checks.

[qwerty]

AFAIK you can use the MySQL driver to access MariaDB. At least it's worth a try.

q.

[Guillaume]

Hi Simon,

Thanks for your reply.
I'm experiencing errors with an addin when using MySQL ODBC on a MariaDB. Since I came across this issue before via other DBMSes, I have a feeling that using the MariaDB ODBC driver could resolve it.

What is the likelihood for the checks to be added for MariaDB driver? I think it's worth trying and I'm happy to test a beta version if you want.

Thanks,
Guillaume
Here is the link to MariaDB ODBC driver: https://mariadb.com/my_portal/download/connector-odbc/1.0/connector-odbc-1.0.5

[Eve]

I'm not sure on your chances with official support for MariaDB. From my point of view, every additional database that we support is an extra headache (and I have enough.) I know in theory it's fully compatible with MySQL, but if it was I don't think you would be having an issue in the first place. Unfortunately, I don't think it would be as simple as I made it sound in my first reply.

What's the error you're getting? Maybe we can resolve that.

[natvig]

I have used MySQL ODBC Driver 5.1.13 together with several MariaDB instances. As far as I can see it works great. Make sure you don't use the driver version 5.2.x or above. I have had some strange issues using the driver versions above 5.1.13. If I remember correctly Sparx also do not recommend versions above 5.1.13.

/Hans