Simon, Thanks, this lead me down the path to the solution. When I made a new DB as you suggested, the code worked fine, indicating that there must have been some problem with the db file. I have no clue what that might have been, but since we're in active development it's possible I interrupted a read or a write with a kill.
Phil -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Friday, February 03, 2012 11:30 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Error 21 on Open (C#) On 3 Feb 2012, at 3:50pm, <phil_wha...@agilent.com> <phil_wha...@agilent.com> wrote: > The result code after conn.Open() is 0. > > I can't check the result code after conn.Close() - that creates an invalid > operation exception: "Database connection not valid for getting result code." > > On the second pass, the conn.Open() result code is still 0. Can you try to do something like this: open INSERT something close open SELECT it and make sure it's still there close I'm curious to find out if you actually are creating a usable database file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
