ODBC-API

Rust ODBC bindings. ODBC (Open Database Connectivity) is an open standard to connect to a variety of data sources. Most data sources offer ODBC drivers. There are two typical usage scenarios for ODBC:

• Your application is designed to work with a wide range of databases without the need of redeploying it.
• There is no native Rust driver in suitable quality available for your database so you want to use the ODBC driver instead.

See also: Is ODBC the Answer?

This crate is currently tested against:

• Microsoft SQL Server
• PostgreSQL
• MariaDB
• SQLite

Current ODBC Version is 3.80.

This crate is built 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.

Usage

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

Installation

To build this library you need to link against the odbc library of your system's 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 connection to a data source, its ODBC driver must also be installed.

Windows

Nothing to do. ODBC driver manager is preinstalled.

Ubuntu

sudo apt-get install unixodbc-dev

macOS

You can use homebrew to install unixODBC

sudo brew install unixodbc

or

You can use MacPorts to install it

sudo port install unixodbc

or

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. sudo make install

Linux / OS-X via Nix Flakes

Alternatively, if you're familiar with the Nix ecosystem or want to try it out, our wiki has a user contributed example on setting up a dev environment with Nix flakes.

Features

• Connect using Data Source names (DSN)
• Connect using ODBC connection strings
• Connect using prompts (windows)
• Log ODBC diagnostics and warnings (via log crate).
• Columnar bulk inserts.
• Columnar bulk queries.
• Rowwise bulk inserts.
• Rowwise bulk queries.
• Output parameters of stored procedures.
• prepared and 'one shot' queries.
• Transactions
• Pass parameters to queries
• Asynchronous execution of one shot queries
• Asynchronous execution of prepared queries
• Asynchronous connecting to database
• Asynchronous fetching of Metainformation
• Multithreading
• Inserting large binary / text data in stream
• Fetching arbitrary large text / binary data in stream
• Connection pooling
• List tables of data sources
• Retrieve multiple result sets