#odbc #database #sql


Write ODBC Applications in (mostly) safe Rust

97 releases (44 breaking)

Uses new Rust 2021

new 0.45.1 Jul 2, 2022
0.44.3 Jun 11, 2022
0.36.1 Mar 25, 2022
0.32.0 Dec 18, 2021
0.10.3 Nov 21, 2020

#94 in Database interfaces

Download history 1317/week @ 2022-03-15 1363/week @ 2022-03-22 1035/week @ 2022-03-29 786/week @ 2022-04-05 1085/week @ 2022-04-12 891/week @ 2022-04-19 1430/week @ 2022-04-26 1346/week @ 2022-05-03 1986/week @ 2022-05-10 1236/week @ 2022-05-17 1343/week @ 2022-05-24 1952/week @ 2022-05-31 1713/week @ 2022-06-07 1427/week @ 2022-06-14 1235/week @ 2022-06-21 953/week @ 2022-06-28

5,644 downloads per month
Used in 8 crates (7 directly)

MIT license

6.5K SLoC


Docs Licence Crates.io Coverage Status

Rust ODBC bindings. ODBC (Open Database Connectivity) is an open standard to connect to a variaty of data sources. Most data sources offer ODBC drivers. This crate is currently tested against:

  • Microsoft SQL Server
  • MariaDB
  • SQLite

Current ODBC Version is 3.80.

This crate is build on top of the odbc-sys ffi bindings, which provide definitions of the ODBC C Interface, but do not build any kind of abstraction on top of it.


Check the guide for code examples and a tour of the features.


To build this library you need to link against the odbc library of your systems ODBC driver manager. It should be automatically detected by the build. On Windows systems it is preinstalled. On Linux and OS-X unix-odbc must be installed. To create a Connections to a data source, its ODBC driver must also be installed.


Nothing to do. ODBC driver manager is preinstalled.


sudo apt-get install unixodbc-dev

OS-X (intel)

You can use homebrew to install UnixODBC

brew install unixodbc


cargo build is not going to pick up libodbc.so installed via homebrew due to the fact that homebrew on ARM Mac installs into /opt/homebrew/Cellar as opposed to /usr/local/opt/.

You find documentation on what directories are searched during build here: https://doc.rust-lang.org/cargo/reference/environment-variables.html#dynamic-library-paths.

You can also install unixODBC from source:

  1. copy the unixODBC-2.3.9.tar.gz file somewhere you can create files and directories
  2. gunzip unixODBC*.tar.gz
  3. tar xvf unixODBC*.tar
  4. ./configure
  5. make
  6. make install


  • Connect using either Data Source names (DSN)
  • Connect using connection strings
  • Connect using prompts (windows)
  • Support for logging ODBC diagnostics and warnings (via log crate).
  • Support for columnar bulk inserts.
  • Support for columnar bulk queries.
  • Support for rowise bulk inserts.
  • Support for rowise bulk queries.
  • Support for Output parameters of stored procedures.
  • Support prepared and 'one shot' queries.
  • Transactions
  • Pass parameters to queries
  • Support for async
  • Support for Multithreading
  • Support for inserting large binary / text data in stream
  • Support for fetching arbitrary large text / binary data in stream
  • Support for connection pooling
  • List tables of data sources


~74K SLoC