19.6. ODBC Previous topic Parent topic Child topic Next topic

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 will also need to install and configure your ODBC manager. The way to do this also depends on your ODBC data manager. For Intersolve DataDirect on Solaris, you will need to set up a .odbc.ini file in your home directory. For Windows, you will need to 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
Use buildsql like this:
buildsql -dbsource dbi:ODBC:datasourcename
      -dbusername user -dbauth password ...