ODBC Driver for SQLite

Connecting to SQLite


  1. After the driver is installed, it can be configured. For this, in the Control Panel open Administrative Tools and find the Data Sources (ODBC) tool:

    Data_Sources_tool

  2. Now you have to add the ODBC Driver for SQLite to the list of System Data Sources or User Data Sources or File Data Sources using the ODBC Data Source Administrator dialog.

    added_DSN

  3. For this, click the Add button - the Create New Data Source dialog will appear with a list of available drivers.

    Select ODBC Driver for SQLite and click Finish.

    create_DSN

    Then you will be suggested to configure the driver.

  4. To activate the driver via ODBC Administrator, refer to the Product Activation article for more details.
  5. Two connection modes are available: using client library and Direct. Direct Mode is used for direct connection to a data source via TCP\IP avoiding client software. Some of the connection options are available in Direct Mode and not required when using client software:

    Using Client Library:

    Client library

    Direct Mode:

    Direct Mode

  6. Then you can click OK and finish configuration or switch to the Advanced settings tab to specify more detailed Connection String. See the full list of supported connection string options in the Connection Options article.
© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback