Here is an example of connecting to SQLite database in Database Tour software.

First, make sure that SQLite is installed on your computer. You can search for sqlite3.dll file.

Installing SQLite

If SQLite was not installed, visit the SQLite download page (use your search engine for finding it) and download precompiled binaries for Windows. They offer separate downloads for 32-bit and 64-bit binaries. If your Windows is 32-bit, download 32-bit binaries. For Windows 64-bit, you can download and use both.

Then, unpack the downloaded archive to a new folder, for example, C:\sqlite (or C:\sqlite-64 for 64-bit binaries).

Connecting to SQLite database

There are several methods to connect to SQLite databases in Database Tour. Here, the recommended method is described: connecting using FD engine. This method provides several SQLite specific tools and faster database-to-database exporting comparing to ODBC and other alternatives.

Note: SQLite binaries can be either 32-bit or 64-bit. To work with SQLite 64-bit, you need to use Database Tour 64-bit, and vice versa. Each Database Tour edition (i.e. Standard and Pro) has both 32-bit and 64-bit versions. On Windows 64-bit, you can install both and use them depending on what type of work you need to do.

So, let's go:

  1. Launch the Database Tour application.
  2. Click Connect / Open Data Source button or choose Database | Connect / Register... menu.
  3. Switch to FD interface.
  4. In the list of database types, choose SQLite.
  5. In the list below, fill the connection parameters. Connecting to SQLite Database The most important parameters are:
    • Vendor library
      It is recommended to specify the vendor library explicitly. It must be a path to sqlite3.dll file from the folder where you installed SQLite. Note: When using Database Tour 32-bit, specify the library from the folder where SQLite 32-bit was installed, otherwise use the path to SQLite 64-bit.
    • Database
      This is a required parameter. Specify a path to existing SQLite database here. You can also create a new SQLite database using the corresponding button to the right and then use its path. To work with in-memory database, specify :memory: instead of the real file path.
    There is a full list of available parameters with their descriptions.
  6. In the Database alias field, specify a friendly name to your database. It will be shown in the list of registered databases to facilitate access to the database.
  7. Click Test to test the connection. In the case of success, click OK to register and open the database. Later, you can access this database by its alias in the list of registered databases or from the drop-down list of the Connect / Open Data Source button .

See also