/odbc-sys

FFI (Foreign Function Interface) bindings for ODBC (Open Database Connectivity) for Rust.

Primary LanguageRustMIT LicenseMIT

odbc-sys

Docs MIT licensed Crates.io version

FFI (Foreign Function Interface) bindings for ODBC (Open Database Connectivity) As ffi bindings to C-APIs are low level by nature this library is intended to be the foundation of other libraries to build on top, rather than to be used directly.

Design Goals

  • Providing declarations of ODBC Symbols compatible to the C-Interface of an ODBC Driver Manager
  • Provide correct definition of symbols for Unix and Windows in either 32Bit or 64Bit flavour
  • Not to abstract away any power of the underlying API
  • Increase type safety where feasible
  • As it is as of now unlikely to happen that anyone is writing ODBC 2.0 applications in Rust therefore deprecated symbols like 'SQLAllocEnv' have been left out intentionally.

Linking

This library will link against odbc32.dll (preinstalled) on Windows systems. On Linux and macOS it links against libodbc.so by default. This is typically provided by unix-odbc. Using the --feature iodbc you can also link against libiodbc.so. This may be interesting if you are trying to connect to some older data sources on macOS.

Installing unix-odbc

Linux

Use your systems packet manager to install unixodbc-dev. E.g. on Ubuntu / Debian

sudo apt install unixodbc-dev

macOS

On Intel based architectures you can install unix-odbc using homebrew.

brew install unixodbc

Note for ARM based macOS Systems (M1 processors and later):

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

Thanks to @TBPixel for testing this!

Windows

As windows does ship with ODBC preinstalled, you are good to go out of the box.

Current State

Symbols are added to this library as we go along implementing uses cases in higher level APIs. If you miss something please do not hesitate to contribute.

Documentation

Thanks to the folks of docs.rs for building and hosting the documentation!

Contributing

Want to help out? Just create an issue or pull request.