(I think Fehmi diagnosed the problem, that you should not use the "sqlite3" command when you are already in the "sqlite3" program. This is about something completely different.) If you are using a recent version of Windows, you do not want to be trying to create your database in the c:\windows\system32 folder. (In Windows Vista or later, you need administrative privileges to write to any file in that folder.) Once SQLite3.exe is installed in the system32 folder, you do not need it to be the current folder to be able to run it (because the system32 folder is in the path). If you use "Start / Run / cmd" to get to a Command Prompt, you can do something like this: md c:\mydb cd c:\mydb sqlite3 test.db so that your data file is not in the system32 folder. (You only need the "md" command the first time, to create the directory.) Once this has been done, you should be able to do Start / Run / sqlite3 c:\mydb\test.db rather than beginning at a Command Prompt. ------------------- Date: Wed, 22 May 2013 11:22:22 -0300
From: Sean Dzafovic <sdzafo...@gmail.com> To: Fehmi Noyan ISI <fnoyan...@yahoo.com>, General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Getting Started with Sqlite Message-ID: <capdp6w+fnhiejkvukn7cukg8hyp1umrhgeop1u0bg8lrnvh...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Wed, May 22, 2013 at 11:17 AM, Fehmi Noyan ISI <fnoyan...@yahoo.com> wrote: > Oh my gosh! you are in business man... [snip] All right. I was doing the command from the shell and not the command line. I will try that later but I have to go offline. I think that may have been my problem though. Thanks for your help. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
