SQLite connection strings

SQLite.NET

Problems connecting?
Get answer in the SQLite Q & A forum

Finisar.SQLite ADO.NET Data Provider

  • Standard

    Data Source=c:\mydb.db;Version=3;

    The "Version" key can take value "2" for SQLite 2.x (default) or value "3" for SQLite 3.x

  • SQLite Version 2.X

    Data Source=c:\mydb.db;Version=2;
  • Create a new database

    Data Source=c:\mydb.db;Version=3;New=True;
  • Using compression

    Data Source=c:\mydb.db;Version=3;Compress=True;
  • Specifying Cache Size

    The Cache Size value represents the amount of data pages that are held in memory. Try increase this value for speed improvements but don't forget to keep track of the applications memory usage.

    Data Source=c:\mydb.db;Version=3;Cache Size=3000;
  • UTF 8

    Data Source=c:\mydb.db;Version=3;UTF8Encoding=True;
  • UTF 16

    Data Source=c:\mydb.db;Version=3;UTF16Encoding=True;

SQLite3 ODBC Driver

  • Standard

    DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0;
    SyncPragma
    =NORMAL;StepAPI=0;

.NET Framework Data Provider for ODBC

  • Use an ODBC driver from .NET

    Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

    See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

Q&Aask question »

Articlesread all »

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.