Oh my gosh! you are in business man... You run the sqlite without any problems, don't you? Have a look at the step-by-step cmd.exe example below As other guys pointed out in their previous posts, you supposed to use "sqlite3 test.db" command from the Windows Command line. Not inside the sqlite shell.
C:\Users\fnoyanisi>d: D:\>cd dev D:\Dev>dir Volume in drive D is Data Volume Serial Number is 918C-D840 Directory of D:\Dev 05/22/2013 11:35 PM <DIR> . 05/22/2013 11:35 PM <DIR> .. 05/22/2013 11:35 PM <DIR> asd 11/13/2012 07:14 PM <DIR> fltk 02/07/2013 08:18 PM <DIR> mingw 02/06/2013 07:57 PM <DIR> msys 03/22/2013 11:28 PM <DIR> myLib 02/17/2013 06:25 PM <DIR> pugixml 03/13/2013 06:33 PM <DIR> python2.7.1 11/16/2012 11:32 PM <DIR> sqlite3 0 File(s) 0 bytes 10 Dir(s) 3,550,380,032 bytes free D:\Dev>cd sqlite3 D:\Dev\sqlite3>dir Volume in drive D is Data Volume Serial Number is 918C-D840 Directory of D:\Dev\sqlite3 11/16/2012 11:32 PM <DIR> . 11/16/2012 11:32 PM <DIR> .. 10/05/2012 05:19 AM 96,378 shell.c 11/16/2012 11:32 PM 4,813,228 sqlite3.c 11/12/2012 10:34 PM 510,464 sqlite3.dll 11/12/2012 10:35 PM 49,152 sqlite3.exe 10/05/2012 05:19 AM 340,171 sqlite3.h 10/05/2012 05:19 AM 24,158 sqlite3ext.h 6 File(s) 5,833,551 bytes 2 Dir(s) 3,550,380,032 bytes free D:\Dev\sqlite3>sqlite3.exe test.db SQLite version 3.7.14.1 2012-10-04 19:37:12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> ________________________________ From: Sean Dzafovic <sdzafo...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, May 22, 2013 11:38 PM Subject: Re: [sqlite] Getting Started with Sqlite On Wed, May 22, 2013 at 10:59 AM, <fnoyan...@yahoo.com> wrote: > The dll and exe should be sufficient to run sqlite. > > What version of sqlite are you using? > sqlite3 --version > > Not sure about this, but may it be something related to user privilages? When I start the shell i see SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> If I use the cmd line i get the path above the SQLite version _______________________________________________ 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
