<!doctypehtml><html lang=en><meta charset=utf-8><meta content=width=device-width,initial-scale=1 name=viewport><link href=/css/styles.min.css?v=YKLM3DWJ0DDX-uyJy_SCSZn07DNxsR81tCKv2z0pJYk rel=stylesheet><title>
   SQLite connection strings - ConnectionStrings.com
  </title><meta content="Connection strings for SQLite. Connect using SQLite.NET, Finisar.SQLite .NET Provider, SQLite3 ODBC and ODBC .NET Provider."name=description><script>(function (i, s, o, g, r, a, m) {
    i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function () {
        (i[r].q = i[r].q || []).push(arguments)
    }, i[r].l = 1 * new Date(); a = s.createElement(o),
        m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m)
    })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga');
    ga('create', 'UA-1015899-1', 'auto');
    ga('send', 'pageview');</script><script async src=https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js></script><body><header class=site-header><a title="Developers number one connection string reference, knowledge base and Q & A forum"class=logo href=/> </a><nav class=site-nav><a href=/> Developers number one Connection Strings reference </a><a href=/kb/> Knowledge Base </a><a href=/questions/> Q & A forums </a></nav><nav class=account-nav><a href=/about/> About </a><a href=/contribute/> Contribute </a><a href=https://www.connectionstrings.com/user/logon/?cancelUrl=https://www.connectionstrings.com/sqlite/ rel=nofollow> log in </a></nav></header><main><header class="content center text-center"><h1 class=connectionstrings-header><a href> SQLite connection strings </a></h1></header><aside class="container row grey mb-2 mob-col"><section class=mb-1><div class="list-head small"><h2>.NET libraries</h2></div><div class="list small cols-1 mob-cols-1 providers"><a title="More info on 'SQLite.NET' and more connection strings"href=/sqlite-net-provider/> SQLite.NET </a><a title="More info on 'Finisar.SQLite ADO.NET Data Provider' and more connection strings"href=/finisar-sqlite-ado-net-data-provider/> Finisar.SQLite ADO.NET Data Provider </a></div></section><section class=mb-1><div class="list-head small"><h2>OLE DB providers</h2></div><div class="list small cols-1 mob-cols-1 providers"><div class=empty></div></div></section><section class=mb-1><div class="list-head small"><h2>ODBC drivers</h2></div><div class="list small cols-1 mob-cols-1 providers"><a title="More info on 'SQLite3 ODBC Driver' and more connection strings"href=/sqlite3-odbc-driver/> SQLite3 ODBC Driver </a></div></section><section class=mb-1><div class="list-head small"><h2>Wrappers and others</h2></div><div class="list small cols-1 mob-cols-1 providers"><a title="More info on '.NET Framework Data Provider for ODBC' and more connection strings"href=/net-framework-data-provider-for-odbc/> .NET Framework Data Provider for ODBC </a></div></section></aside><div class="content center mb-2"><div class=ad><ins class=adsbygoogle data-ad-client=ca-pub-0496710909277617 data-ad-format=auto data-ad-slot=7815821994 data-full-width-responsive=true style=display:block;> </ins><script>(adsbygoogle = window.adsbygoogle || []).push({});</script></div></div><div class="content center mb-2"><section><article><header><h2 class=library id=sqlite-net-provider><a href=/sqlite-net-provider/> SQLite.NET </a></h2></header><div class=connectionstrings><article><header><h3><a href=/sqlite-net-provider/basic/> Basic </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>Version 2 is not supported by this class library.</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/in-memory-database/> In-Memory Database </a></h3></header><section><p>An SQLite database is normally stored on disk but the database can also be stored in memory. Read more about <a href=http://www.sqlite.org/inmemorydb.html target=_blank> SQLite in-memory databases here </a> .</p><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> :memory:; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> New </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/using-utf16/> Using UTF16 </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> UseUTF16Encoding </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/with-password/> With password </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Password </span> = <span class=value> myPassword; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><aside><div class=ad><ins class=adsbygoogle data-ad-client=ca-pub-0496710909277617 data-ad-format=fluid data-ad-layout-key=-hg-4+1o-6l+95 data-ad-slot=6567215459 style=display:block;> </ins><script>(adsbygoogle = window.adsbygoogle || []).push({});</script></div></aside><article><header><h3><a href=/sqlite-net-provider/using-the-pre-33x-database-format/> Using the pre 3.3x database format </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Legacy Format </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/with-connection-pooling/> With connection pooling </a></h3></header><section><p>Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.</p><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Pooling </span> = <span class=value> True; </span> </span>
          <span class=kvp> <span class=key> Max Pool Size </span> = <span class=value> 100; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/read-only-connection/> Read only connection </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Read Only </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/using-datetimeticks-as-datetime-format/> Using DateTime.Ticks as datetime format </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> DateTimeFormat </span> = <span class=value> Ticks; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>The default value is ISO8601 which activates the use of the ISO8601 datetime format</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/store-guid-as-text/> Store GUID as text </a></h3></header><section><p>Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.</p><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> BinaryGUID </span> = <span class=value> False; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>Note that storing GUIDs as text uses more space in the database.</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/specify-cache-size/> Specify cache size </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Cache Size </span> = <span class=value> 2000; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>The Cache Size value measured in bytes</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/specify-page-size/> Specify page size </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Page Size </span> = <span class=value> 1024; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>The Page Size value measured in bytes</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/disable-enlistment-in-distributed-transactions/> Disable enlistment in distributed transactions </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Enlist </span> = <span class=value> N; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/disable-create-database-behaviour/> Disable create database behaviour </a></h3></header><section><p>If the database file doesn't exist, the default behaviour is to create a new file. Use the following parameter to raise an error instead of creating a new database file.</p><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> FailIfMissing </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/limit-the-size-of-database/> Limit the size of database </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Max Page Count </span> = <span class=value> 5000; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>The Max Page Count is measured in pages. This parameter limits the maximum number of pages of the database.</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/disable-the-journal-file/> Disable the Journal File </a></h3></header><section><p>This one disables the rollback journal entirely.</p><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Journal Mode </span> = <span class=value> Off; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/persist-the-journal-file/> Persist the Journal File </a></h3></header><section><p>This one blanks and leaves the journal file on disk after a commit. Default behaviour is to delete the Journal File after each commit.</p><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Journal Mode </span> = <span class=value> Persist; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/sqlite-net-provider/controling-file-flushing/> Controling file flushing </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Synchronous </span> = <span class=value> Full; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>Full specifies a full flush to take action after each write. Normal is the default value. Off means that the underlying OS flushes I/O's.</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article></div><aside class=qagate><span> ↯ <strong> Problems connecting </strong> ? </span><div>Get answer in the <a href=/sqlite/questions/> SQLite Q & A forum </a></div></aside></article><article><header><h2 class=library id=finisar-sqlite-ado-net-data-provider><a href=/finisar-sqlite-ado-net-data-provider/> Finisar.SQLite ADO.NET Data Provider </a></h2></header><div class=connectionstrings><article><header><h3><a href=/finisar-sqlite-ado-net-data-provider/standard/> Standard </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>The "Version" key can take value "2" for SQLite 2.x (default) or value "3" for SQLite 3.x</section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/finisar-sqlite-ado-net-data-provider/sqlite-version-2x/> SQLite Version 2.X </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 2; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/finisar-sqlite-ado-net-data-provider/create-a-new-database/> Create a new database </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> New </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/finisar-sqlite-ado-net-data-provider/using-compression/> Using compression </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Compress </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/finisar-sqlite-ado-net-data-provider/specifying-cache-size/> Specifying Cache Size </a></h3></header><section><p>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.</p><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> Cache Size </span> = <span class=value> 3000; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/finisar-sqlite-ado-net-data-provider/utf-8/> UTF 8 </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> UTF8Encoding </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article><article><header><h3><a href=/finisar-sqlite-ado-net-data-provider/utf-16/> UTF 16 </a></h3></header><section><code>
          <span class=kvp> <span class=key> Data Source </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> Version </span> = <span class=value> 3; </span> </span>
          <span class=kvp> <span class=key> UTF16Encoding </span> = <span class=value> True; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article></div></article><article><header><h2 class=library id=sqlite3-odbc-driver><a href=/sqlite3-odbc-driver/> SQLite3 ODBC Driver </a></h2></header><div class=connectionstrings><article><header><h3><a href=/sqlite3-odbc-driver/standard/> Standard </a></h3></header><section><code>
          <span class=kvp> <span class=key> DRIVER </span> = <span class=value> SQLite3 ODBC Driver; </span> </span>
          <span class=kvp> <span class=key> Database </span> = <span class=value> c:\mydb.db; </span> </span>
          <span class=kvp> <span class=key> LongNames </span> = <span class=value> 0; </span> </span>
          <span class=kvp> <span class=key> Timeout </span> = <span class=value> 1000; </span> </span>
          <span class=kvp> <span class=key> NoTXN </span> = <span class=value> 0; </span> </span>
          <span class=kvp> <span class=key> SyncPragma </span> = <span class=value> NORMAL; </span> </span>
          <span class=kvp> <span class=key> StepAPI </span> = <span class=value> 0; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments></section><aside class="list tags small right"><a href=/sqlite> SQLite </a></aside></div></article></div></article><article><header><h2 class=library id=net-framework-data-provider-for-odbc><a href=/net-framework-data-provider-for-odbc/> .NET Framework Data Provider for ODBC </a></h2></header><div class=connectionstrings><article><header><h3><a href=/net-framework-data-provider-for-odbc/use-an-odbc-driver-from-net/> Use an ODBC driver from .NET </a></h3></header><section><code>
          <span class=kvp> <span class=key> Driver </span> = <span class=value> {any odbc driver's name}; </span> </span>
          <span class=kvp> <span class=key> OdbcKey1 </span> = <span class=value> someValue; </span> </span>
          <span class=kvp> <span class=key> OdbcKey2 </span> = <span class=value> someValue; </span> </span>
         </code></section><div class=comments-and-tags-container><section class=comments><p>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 <a title="Use .net OdbcConnection to connect with ODBC drivers"href=/net-framework-data-provider-for-odbc target=_blank> here </a> .</section></div></article></div></article></section><aside><div class=list-head><h2><a href=/sqlite/questions/> Questions </a></h2><a class=more href=https://www.connectionstrings.com/questions/ask/?tag=sqlite&cancelUrl=https://www.connectionstrings.com/sqlite/> ask question » </a></div><div class="list cols-1 mb-2"><a title="With the following in my C# Visual Studio .NET Core Winforms app, I'm getting &ampquot;unable to open database file&ampquot;:
using System.Data.SQLite;
. . .
string cs = &ampquot;Data Source=\F4FDataSQLite_SingleTable.db;&ampquot;;
"href=/questions/100081/getting-unable-to-open-database-file-with-this-minimal-connection-string/> Getting "unable to open database file" with this minimal connection string </a><a title="how to create dns-less connection from ms access to sqlite
"href=/questions/100064/dns-less-connection-to-sqlite/> DNS-less connection to sqlite </a><a title="I'm trying to create a program that communicates with a SQLite database encrypted by a password. If I try with a db without any password it work, but with a database with password, after connecting, when executing the query it gives the error &ampquot;File is not a database&ampquot;. This is the code:
"href=/questions/100038/connection-with-sqlite-db-encrypted/> Connection with SQLite db encrypted </a><a title="I have a Visual Studio 2017 .NET 2.2 Core Razor Pages project 
I have downloaded and installed the ODBC sqlite3 driver.
I can see my sqlite database in Visual Studio Server Explorer and I can open tables and see rows.
"href=/questions/54113/i-cannot-configure-a-working-odbc-connection-string-for-sqlite-in-aspsettings-json-for-net-core-razo/> I cannot configure a working ODBC connection string for SQLite in aspsettings.json for .NET CORE Razor Pages </a><a title="Hello programmer friend I made a program C # .net with visual studio connected to a database sqlite which I made the executable to be able to run it on other pc but the problem is that I can not to save in my database ... here is the error:
"href=/questions/52513/c-net-connected-to-sqlite/> c# .NET connected to sqlite </a></div><div class=list-head><h2><a href=/kb/> Articles </a></h2><a class=more href=/kb/> view all » </a></div><div class="list cols-1 mb-2"><a title="There are no built in checks or constraints on how to format a connection string. This walk-through shows the basic rules for creating a connection string that will work."href=/formating-rules-for-connection-strings/> Formating Rules for Connection Strings </a><a title="Connection strings can be a bit obscure and are often not defined consistently. This article straightens things out and sheds some light on how connection strings are used to connect an application to a data source."href=/connection-strings-explained/> Connection Strings Explained </a><a title="It is very easy to store the connection string in a config file and there are several benefits in doing so. This article describes why and how to store the connection string in web.config."href=/store-connection-string-in-webconfig/> Store Connection String in Web.config </a><a title="To get the most out of connection pooling there are some things to keep in mind when developing your application. Learn to stay away from the pitfalls and utilize the full power of connection pooling."href=/connection-pooling/> Connection Pooling </a><a title="Behind the Provider keyword is a chain of mappings to the software implementation contained in a dll file. This article explains that chain and how COM works in general."href=/provider-progid-com-clsid/> The Provider Keyword, ProgID, Versioning and COM CLSID Explained </a><a title="There are different ways to store and read connection strings in appsettings.json. Learn some easy ways to work with connection strings in .NET Core."href=/store-and-read-connection-string-in-appsettings-json/> Store and read connection string in appsettings.json </a><a title="Do you know exactly every sql data type in SQL Server and their usage and storage requirements? If not, look them all up in this reference sheet."href=/sql-server-data-types-reference/> SQL Server Data Types Reference </a><a title="To explicitly define which network protocol to use when connecting to an SQL Server gives you more control over your connection. This guide explains how to do that."href=/define-sql-server-network-protocol/> Network Protocol for SQL Server Connection </a><a title="There are plenty of combinations when creating an SQL Server connection string. This reference table explains each option available per keyword."href=/all-sql-server-connection-string-keywords/> All SQL Server SqlConnection Properties </a><a title="The SQL Native Client should only be used in certain contexts. This is the definition of when to use it, and when not to."href=/sql-native-client-use/> When to use the SQL Native Client </a></div></aside></div><aside class="container row mob-hidden"><div class=mb-2><div class=list-head><h2>Connect to</h2></div><div class="list cols-3 datasources"></div></div><div class=mb-2><div class=list-head><h2><a href=/kb/> Articles </a></h2><a class=more href=/kb/> read all » </a></div><div class="list cols-2"><a title="There are no built in checks or constraints on how to format a connection string. This walk-through shows the basic rules for creating a connection string that will work."href=/formating-rules-for-connection-strings/> Formating Rules for Connection Strings </a><a title="Connection strings can be a bit obscure and are often not defined consistently. This article straightens things out and sheds some light on how connection strings are used to connect an application to a data source."href=/connection-strings-explained/> Connection Strings Explained </a><a title="It is very easy to store the connection string in a config file and there are several benefits in doing so. This article describes why and how to store the connection string in web.config."href=/store-connection-string-in-webconfig/> Store Connection String in Web.config </a><a title="To get the most out of connection pooling there are some things to keep in mind when developing your application. Learn to stay away from the pitfalls and utilize the full power of connection pooling."href=/connection-pooling/> Connection Pooling </a><a title="Behind the Provider keyword is a chain of mappings to the software implementation contained in a dll file. This article explains that chain and how COM works in general."href=/provider-progid-com-clsid/> The Provider Keyword, ProgID, Versioning and COM CLSID Explained </a><a title="There are different ways to store and read connection strings in appsettings.json. Learn some easy ways to work with connection strings in .NET Core."href=/store-and-read-connection-string-in-appsettings-json/> Store and read connection string in appsettings.json </a><a title="Do you know exactly every sql data type in SQL Server and their usage and storage requirements? If not, look them all up in this reference sheet."href=/sql-server-data-types-reference/> SQL Server Data Types Reference </a><a title="To explicitly define which network protocol to use when connecting to an SQL Server gives you more control over your connection. This guide explains how to do that."href=/define-sql-server-network-protocol/> Network Protocol for SQL Server Connection </a><a title="There are plenty of combinations when creating an SQL Server connection string. This reference table explains each option available per keyword."href=/all-sql-server-connection-string-keywords/> All SQL Server SqlConnection Properties </a><a title="The SQL Native Client should only be used in certain contexts. This is the definition of when to use it, and when not to."href=/sql-native-client-use/> When to use the SQL Native Client </a></div></div></aside></main><footer><nav><a href=/> connectionstrings </a><a href=/kb/> articles </a><a href=/search/> search </a><a href=/questions/> Q & A </a><a href=/questions/ask/> ask question </a><a href=/contribute/> contribute </a><a href=/retrospective/> retro </a><a href=/about/> about </a><a href=/contact/> contact </a><a href=/user/logon/> log in </a><a href=/user/signup/> join </a></nav><section><div>Copyright 2021, © ConnectionStrings.com - All Rights Reserved</div><div>Powered by CSAS on .NET 5.0.6</div><div>Made possible by <a href=/contribute/> Contributing Developers </a></div></section></footer><script>var infolinks_pid = 3240994;
var infolinks_wsid = 0;</script><script src=//resources.infolinks.com/js/infolinks_main.js></script>