skills.rest
mariadb-corporation
mariadb-corporationOFFICIAL
Explore all skills by this author →
WebsiteGitHub

mariadb-connector-odbc-install

Installs and registers MariaDB Connector/ODBC with driver managers and configures DSNs.

28|115|Updated Jan 28, 2025
Search Tags:#ODBC#tls#mariadb#connection string#driver installation#dsn configuration#unixodbc
One-click install
npx skills add https://github.com/mariadb-corporation/mariadb-docs --skill mariadb-connector-odbc-install-mariadb-corporation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mariadb-connector-odbc-install
Source: https://github.com/mariadb-corporation/mariadb-docs/tree/main/agent-skills/granular/connectors/mariadb-connector-odbc-install
Command: npx skills add https://github.com/mariadb-corporation/mariadb-docs --skill mariadb-connector-odbc-install-mariadb-corporation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? ODBC connections to MariaDB usually fail before the first query: the driver manager cannot find the driver, bitness mismatches between driver and manager, or DSNs written to files nothing reads. This Skill guides correct installation, registration, and configuration of MariaDB Connector/ODBC on Linux, macOS, and Windows. ## Core Features & Use Cases - Driver Manager Registration: Register the driver with unixODBC, iODBC, or the Windows ODBC manager using odbcinst and template .ini files, including the ODBCSYSINI, ODBCINI, and ODBCINSTINI environment variables. - DSN and Connection-String Configuration: Define system and user DSNs with canonical keywords (UID, PWD, SERVER, PORT, DATABASE) and TLS keywords (SSLCA, SSLVERIFY, FORCETLS, TLSVERSION). - Use Case: You need a Linux application server to reach a MariaDB database over ODBC with verified TLS. Use this Skill to install unixODBC, register the 3.2 driver, create a system DSN, and verify it with isql before touching the application. ## Quick Start Install and register MariaDB Connector/ODBC on this Linux machine and create a verified system DSN for my database server.

Frequently Asked Questions about mariadb-connector-odbc-install

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I install MariaDB Connector/ODBC on Linux?▼

Install unixODBC and its tools first (apt install unixodbc odbcinst, or yum install unixODBC), then install the downloaded driver package. Register the driver with sudo odbcinst -i -d -f using a template file pointing to libmaodbc.so.

How do I create an ODBC DSN for MariaDB?▼

Write a template .ini file with Driver, SERVER, PORT, UID, PWD, and DATABASE entries, then run odbcinst -i -s -l -f for a system DSN or -i -s -h -f for a user DSN. The driver does not support the unixODBC GUI for adding DSNs.

Why does my ODBC connection say data source name not found?▼

This error means the driver manager cannot resolve the DSN or driver registration. Check that the driver is registered in odbcinst.ini, that ODBCSYSINI, ODBCINI, and ODBCINSTINI point where expected, and that driver and manager bitness match.

Does MariaDB Connector/ODBC require Connector/C installed separately?▼

No. The binary driver packages carry Connector/C with them and are self-contained. A source build can use the bundled libmariadb submodule or link the system one, but an installed package needs nothing extra.

How do I enable TLS verification in an ODBC connection string?▼

Set SSLCA to your CA certificate path and SSLVERIFY=1 so the server proves its identity against that CA. FORCETLS=1 refuses unencrypted connections, and TLSVERSION restricts protocol versions.

How do I test an ODBC DSN outside my application?▼

Run isql <dsn> with unixODBC or iodbctest "DSN=<dsn>" with iODBC. This separates driver-manager registration problems from application-level connection issues.

Related Skills

Explore More Software Engineering Skills→
sukbearaisukbearai
4

bytevirt-hysteria2-node

Provision and audit ByteVirt VPS servers as no-panel Hysteria2 UDP proxy nodes.

Community
Advanced
sorodriguezzsorodriguezz

Using the InterSystems ODBC Driver

Guide ODBC driver installation, DSN setup, and connection configuration for InterSystems databases.

Community
Intermediate
SunriseSummerSunriseSummer
1

cangjie-https-client

Configure TLS clients and make HTTPS requests in Cangjie with OpenSSL 3.

Community
Advanced
ContrastingSoundsContrastingSounds

rill-connector

Define and manage Rill connectors with secure credential storage and configuration.

Community
Advanced