When you open the command prompt you will see something like this: c:\PINTS>sqlite3.exe SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>
The above clearly indicates version 3.6.10. Others on the list will correct me if I am wrong, but the command line utility does not use the DLL. If the path to the exe file is in your windows PATH environment variable folder you will be able to execute it. I normally start it from a command prompt (Start->run "cmd") regards, Adam On Wed, May 22, 2013 at 9:51 AM, Sean Dzafovic <sdzafo...@gmail.com> wrote: > On Wed, May 22, 2013 at 10:30 AM, Igor Tandetnik <i...@tandetnik.org> wrote: >> On 5/22/2013 8:58 AM, Sean Dzafovic wrote: >>> >>> I downloaded the shell and the dll from the sqlite.org site. I put the >>> .dll in the windows/system32 folder. However, when I try to create a >>> test db using the command "sqlite3 test.db" as per the example, I get >>> "Error: near "sqlite3" :syntax error. >>> >>> What am I doing wrong? >> >> >> You are running this command on sqlite3 command line (do you see "sqlite3>" >> prompt?) Instead, you should run this command on Windows command line (Start >>> Run > cmd), in order to start sqlite3 shell with a given DB file as a >> parameter. > > Tried it with the shell on my desktop and got the error. > Moved it to the system32 folder along with the .dll and got the same > error. (Both of these by clicking on the icon). > > Same when I tried using the Windows command line. > > Either way when I open the shell it gives me a sqlite> prompt, not sqlite3> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- VerifEye Technologies Inc. 905-948-0015x245 151 Whitehall Dr, Unit 2 Markham ON, L3R 9T1 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
