problem about "You appear not to have the 'sqlite3' program installed or on your path."

[jason zones]

hello, all.

i have a problem when i type "python manage.py dbshell" in the commandline within the mysite folder. i used sqlite3 as the db.

when i typed the command, it showed the error "You appear not to have the 'sqlite3' program installed or on your path."

my installed python version is 2.6 and it is said the sqlite3 being a module in the python, so i tried "import sqlite3", and it worked. so it seemed sqlite3 module was there in the python, but it just cannot go into the dbshell with "python manage.py dbshell" as the djangobook told. i also tried to append the dir"c:\python26\Lib\sqlite3" to the sys path, but it seemed not work.  my operating system is windows xp, anyone knows what's wrong?

many thanks.

[Ramiro Morales]

There are two thing named sqlite3 at play here:

First, the sqlite3 module that is part of the standard library for Python 2.5
and newer. The fact that's it's included means, in your platform, some files
and directories named sqlite3.* and _sqlite3 under your C:\python2x
installation directory, but you aren't supposed to mess with them because they
are an implementation detail and you'd be breaking your Python installation if
you did (just for completeness: they are the SQLite library in a dynamic
library form and the Python DB-API 2module that allows Python programs like
Django to access SQLite databases).

Second there is the sqlite3.exe utility that can be download from SQLIte web
site. It's a program that also knows how to access SQLite databases because it
includes the SQLite library compiled statically for its own use (so the program
can be used in an standalone fashion).

The dbshell Django management command uses this utility. So you need
to download sqlite3.exe if you want to use it.

Regards,

--
Ramiro Morales

[jason]

understood. thanks very much:-)

[jason]

another question, but where should i put the 'sqlite3.exe' in order to
use the 'python manage.py dbshell' command?

> >  Ramiro Morales- Hide quoted text -
>
> - Show quoted text -

[osamu]

I'm stuck here as well, donno where i should put sqlite3.exe in order
to use it

[Johan]

If i remember correctly anywhere on the path should be fine.