Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!

As you can see in the screenshot above, when the program was started it got connected to the database, opened the data set, and using the data source, displayed the content in the grid. Connection to an SQLite Database via ADO The next task that we will fulfill is the connection to an SQLite database using the ADO technology. We will need the same component set that’s why we offer to continue working with an app, changing just the way of getting connected to a database. But before we proceed to settings we need to install a provider for SQLite databases into the system. You can download it following the link http://www.ch-werner.de/sqliteodbc/ Now we need to come back to settings. Again let’s open the ConnectionString property of the ADOConnection1 component for editing. Now let’s choose another provider. It will be the Microsoft OLE DB Provider for ODBC Drivers.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.