When using directories with spaces, its better (or necessary) to include the whole directory in double quotes. Therefore, try entering this: sqlite3 "e:\VB Resources\SQLite\chinook.db"
No problems with being a novice - everyone was a novice once. Thanks, Chris On Mon, Aug 13, 2018 at 1:15 PM Roger Schlueter <drrog...@cox.net> wrote: > I am just starting to learn SQLite so I am afraid my questions here will > be quite simple for a (very long?) while compared to those I have been > reading. I'm starting by trying to follow the tutorial. > > I have SQLite, the GUI, and chinook.db installed on Windows 10 but not > in the default directories. In the cmd window I have this: > > C:\Program Files\SQLite>sqlite3 e:\"VB Resources"\SQLite\chinook.db > Error: unable to open database "e:"VB": unable to open database file > > It appears that SQLite does not like directory names with embedded > blanks. Is that correct? If so, is there a workaround? > > Roger > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
