Windows Command prompt shell for sqlite3

Question

The documentation states that there is a command-line shell for sqlite3:

To start the sqlite3 program, just type "sqlite3" followed by the name the file that holds the SQLite database."

When I try this, in the Windows Command Prompt I get the error message:

'sqlite3' is not recognized as an internal or external command, operable program or batch file.

Windows explorer reveals several 'Sqlite3" folders in various places:

backends(C:/Python26/Lib/site-packages/django/db)
Lib(C:/Python26)
backends(C:/Django-1.1.1/Django-1.1.1/build/lib/django/db
backends(C:/Django-1.1.1/Django-1.1.1/django/db)

How do I access the shell, can anyone help?

Answer 1

That's the error message you get if you try to run any executable that's not in your current directory or in the path.

To correct the problem, find the SQLite executable (SQLITE3.EXE), and run it from the directory in which it resides, or add SQLITE3.EXE to your PATH environment variable.