Richard Hipp wrote: > On Wed, Feb 19, 2014 at 5:25 PM, Jeff Archer < > jsarc...@nanotronicsimaging.com> wrote: > >> Long time SQLite user but I don't think I have ever tried to do an >> in-memory database before. >> Just upgraded to 3.8.3.1 but I am not having any other failures with >> existing code so I don't think that is any part of the problem. >> I am trying to open the database with sqlite3_open16() using a filename of >> L":MEMORY:". I am getting a result code of 14 which is SQLITE_CANTOPEN. >> It does open if I use a real filename. > > The magic name is case-sensitive and lower-case. Use L":memory:" and it > should work for you.
... and also note that passing L"..." string constants (and everything else of `wchar_t *` type) to sqlite3_*16() *very* bad idea (on nearly all non-windows platforms wchar_t is 32-bit int ucs-32, sqlite3_*16() expects 16-bit/utf-16, depending on platform endianness it will try to open ":" [which will silently succeed, but open *on-disk* database in current directory, extremely nasty!] or "" [which will likely fail]). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users