Comments - Using MariaDB on Linux from C++ ODBC
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
What exactly are you trying to do?
If you just want to access a MariaDB database, you don't need the overhead of ODBC, which is an inter-process communications and data access translation service. You just need to make libmysql calls with your SQL.
If you want a portability layer (and can afford the performance hit), such that you could easily switch to anything from Oracle to SQLite, then ODBC is your guy. Otherwise, just make libmysql calls.
Many thanks for the quick reply.
I am trying to access MariaDB from an existing C++ package that uses ODBC to talk to databases. I don't have the option to write my own code.
I've used MySQL in the past (several years ago) and was able to install an ODBC driver then - DRIVER={MySQL ODBC 3.51 Driver} to be explicit. I have not found a way to install a driver for MariaDB.
Using MariaDB is no different from using MySQL from the client side. The same ODBC driver you used previously should work fine with MariaDB.
I think I understand. MariaDB does not have an ODBC driver and I should use a MySQL driver.
My SUSE 13 repository does not have MySQL but I'll search for a repository where I can download it.
Thanks to everyone for your responses.