HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Connection string for MariaDB using ODBC

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
odbcconnectionusingforstringmariadb

Problem

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?

Solution

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

Code Snippets

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

Context

StackExchange Database Administrators Q#111233, answer score: 2

Revisions (0)

No revisions yet.