Open Database Connectivity for Covariant Script

March 12, 2021 ยท View on GitHub

Special Notice: It's not recommended to use SQLite3 via ODBC Driver while Covariant Script have native SQLite3 support.

Official Build & Tested Platform

PlatformData Source AdministratorODBC Driver
Microsoft WindowsODBC Data SourcesMariaDB ODBC Driver
Microsoft WindowsODBC Data SourcesMySQL ODBC Driver
Apple macOSiODBCMariaDB ODBC Driver
Ubuntu 20.04unixODBCMariaDB ODBC Driver

Preparation

Windows

Download and install MariaDB ODBC Driver

macOS

  1. Download iODBC
  2. Download MariaDB ODBC Driver

Linux

  1. Install unixODBC: sudo apt install unixodbc
  2. Install MariaDB ODBC Driver: sudo apt install odbc-mariadb

Configuration

  1. MariaDB
    • If it doesn't work properly on Ubuntu after following the official documentation, try modifying the configuration file: Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
  2. MySQL