ODBC is a widely used Application Programming Interface (API) that enables any application on a client computer to access data sources on a server using SQL.
In an ODBC architecture, applications connect to an ODBC driver manager, which in turn uses a specific ODBC driver to establish a connection to a data source. The client-side component of the driver, which works directly with the application, must strictly comply with the ODBC standard. The application doesn't need to know which database management system (DBMS) is installed on the server. The server-side component of the driver is tailored to a specific database. Due to this architecture, there is no need to configure the application for a particular DBMS.
Advantages of the ODBC Driver for SQLite
Native data connectivity
The SQLite ODBC Driver fully supports standard ODBC API functions and data types and provides easy access to live SQLite data from anywhere. Also, the Driver is compatible with the SQLite API itself.
Real-time data access
The Driver allows accessing data directly from an ODBC-compliant application in real time, which provides a dynamic workspace that adapts and changes as quickly as your data.
Integration
The Driver is compatible with database management solutions, analytics and reporting tools, programming languages, and IDEs. This allows you to view, update, manage, and edit your data using the tool you are working with.
Platforms variety
You can use the ODBC Driver for SQLite with a 32-bit or 64-bit application on both x86 and x64 versions of Windows, Linux, and macOS. No additional drivers or application configurations are required.
SQLite database encryption
To protect your data from unauthorized access, our ODBC driver for SQLite includes a powerful and customizable SQLite database encryption engine. You no longer need to spend money on expensive SQLite client libraries that support encryption.
Installation process
The Devart ODBC Driver is easy to install. All you need is to download it on your computer and follow the installation wizard instructions.
Windows
1. Download the installation executable file of the ODBC Driver for SQLite, open it, and click Next.
2. On the License Agreement page, read the agreement terms. After that, select I accept the agreement and click Next.
3. Browse the destination folder for the Devart ODBC Driver for SQLite and click Next.
4. On the Select Components page, select the components you want to install and click Next.
5. On the Select Start Menu Folder page, specify where the program's shortcuts should be placed. If you don't want the Start Menu folder to be created, select Don't create a Start Menu Folder. Then, click Next.
6. To initiate the installation process, click Install.
7. On the License Information page, choose the license type. If you select Activation Key, insert the corresponding key into the field or click Load Activation Key to browse it on your machine. Then, click Next.
You can install the Devart ODBC Driver for SQLite on Linux using two installer packages, depending on the distribution you are using.
If you want to install the Driver on Ubuntu, which is a popular open-source Linux distribution based on Debian, then you need to install the .deb package corresponding to the bitness of your operating system.
There are also two ways to install the Driver, either manually or via the command line.
In case you need to install the Driver on CentOS, then it's required to install the .rpm package.
Let's review each method.
GUI installation
1. Download the package of the required bitness from the Devart website.
2. Right-click the downloaded package and choose the necessary option for opening it.
3. In the dialog that opens, click Install.
Command-line installation
1. Open Terminal and go to the folder with the downloaded package.
cd path_to_package
2. To install the Devart ODBC Driver for SQLite from the .deb package, run the following command.
sudo dpkg -i package_name
You should see that the Driver is installed successfully.
To install the Driver from the .rpm package, run the following command.
3. After reading the Software License Agreement, click Agree to go further.
4. In the License Information dialog, you should select the license type and activate the product. If you have no activation key, you can select Trial and use the Driver for evaluation purposes. If you have the activation key, select Activation Key and paste it.
5. To proceed with the installation, click Continue.
6. Finally, click Install.
7. To close the Wizard, click Close.
Configure an ODBC Data Source Name
After the Driver is installed, you should create the Data Source Name (DSN) for your ODBC connection and test it.
Windows
1. Open the ODBC Data Source Administrator and go to the User DSN or System DSN tab. Most applications work with both types, but some require a specific one.
2. Click Add.
3. Select Devart ODBC Driver for SQLite and click Finish.
4. Enter the connection details in the appropriate fields and click Test Connection to confirm connectivity.
You should see the notification about the successful connection.
5. To save the DSN, click OK.
Linux
After you have installed the Driver from the .deb or .rpm package, the DEVART_SQLITE DSN is created. You can use it to test the connection with a SQLite database. To do it:
1. In the /etc/odbc.ini file, find the DEVART_SQLITE section, and specify the required connection settings.
Database=your SQLite database name
2. In Terminal, run the UnixODBC Test Command utility and test the connection using the following command.
isql -v DEVART_SQLITE
This output means that the connection is successful.
macOS
1. To configure the ODBC Driver for SQLite on macOS, run the iODBC utility of the required bitness. Find DEVART_SQLITE and click Configure.
2. In the dialog that appears, specify the required connection settings and click OK.
3. To verify the connection, click Test.
You should see that the connection was tested successfully and you can use it.
How SQLite database encryption works
SQLite provides functionality for working with encrypted databases. When encryption is enabled, all data stored in the database file is automatically encrypted and decrypted during read or write operations.
This ensures security even if there is physical access to the file — without the correct key (password), it cannot be read.
Encryption is implemented using external extensions such as SQLCipher or SEE (SQLite Encryption Extension), as the standard version of SQLite does not support encryption out of the box.
Thus, encryption of a SQLite database provides reliable protection for sensitive information without significant changes to the application logic.
For more details, refer to the How SQLite Database Encryption Works topic.
ODBC Drivers
Reliable and simple to use data connectors for ODBC data sources. Compatible with multiple third-party tools.
