🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Does Altair SLC support access to SQLite databases?

User: "Nico Chart_21517"
Altair Employee
Updated by 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.

Find more posts tagged with

Comments

No comments on this post.