Re: [sqlite] Connection open to nonexistent database succeeds! WTF?

It looks like you're using C# and System.Data.SQLite. If that's the case, use the connection string parameter FailIfMissing=True to throw an exception if the file does not exist. On 1 April 2018 at 02:34, Jens Alfke wrote: > > > On Mar 31, 2018, at 8:17 AM, Mike Clark

Re: [sqlite] Connection open to nonexistent database succeeds! WTF?

> On Mar 31, 2018, at 8:17 AM, Mike Clark wrote: > > Is this expected behavior? Yes. If the database file doesn’t exist, opening it will create it. (That’s how you create new databases.) There is a flag to sqlite3_open (in the C API) that prevents creating a file.

[sqlite] Connection open to nonexistent database succeeds! WTF?

I've written the following code for the ADO.NET client for SQLite, and the odd thing I've noticed is that even when the connection string passed to it does not refer to a file that exists, the code returns true! Does SQLite not actually check for a valid connection until you try to perform a data