To use ODBC, you must first create the database and tables in
a way that depends on the type of database to which you are going to
connect. See your vendor's documentation. You need to install and
configure your ODBC manager. The way to do this also depends on your ODBC
data manager.
For example, on Linux, macOS and other Unix systems,
ODBC configuration typically is done with
odbcinst.ini
and odbc.ini
files
in /etc
, /usr/local/etc
,
$HOME
or other directory that depends on the system.
For Windows, use the ODBC administration tools and add a System DSN (data
source name).
Configure your SQL clause like this:
DBSource dbi:ODBC:datasourcename
DBUsername user
DBAuth password