What is the connection string for using MariaDB with ODBC?

I'm guessing it's something like

DRIVER={MariaDB ODBC 5.1 Driver}; SERVER=LOCALHOST; PORT=3306; DATABASE=DatabaseName; UID=root; PASSWORD=password;OPTION=3;

Connection strings seems to show strings for MySQL but not MariaDB.

MariaDB seems to have a lot of connection strings for Access, SQL Lite, excel, etc ...

What have I missed?

1 Answer 1


Although this is late answer, but MariaDB have that documented here

SQLWCHAR *ConnStr= L"Driver={MariaDB ODBC 2.0 Driver};Server=localhost;UID=odbc_user;PWD=odbc_pw;DB=odbc_test;Port=3306";

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.