Does Altair SLC support access to SQLite databases?

Nico Chart_21517

Yes, with limitations, via LIBNAME ODBC.

Operations on SQLite files via ODBC do not support update or delete actions.

A SQLite database is a file-based database, so there is no server to connect to.

A simple LIBNAME statement can establish access to tables within a named SQLite file:

LIBNAME db ODBC dsn=mylitefile;

The SQLite ODBC Driver (either the vanilla version or the UTF-8 version) from Christian Werner Software needs to be installed on the PC or Windows Server where Altair SLC is running, and a DSN using that driver must be configured to reference your SQLite filename.