windows 7 pysqlite build error

[Robin Becker]

I am getting this error trying to use a python27 pip install of stuff which ends 
up requiring pysqlite>=2.6.3,<2.7

> building 'pysqlite2._sqlite' extension
>
> creating build\temp.win-amd64-2.7
>
> creating build\temp.win-amd64-2.7\Release
>
> creating build\temp.win-amd64-2.7\Release\src
>
> c:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\BIN\amd64\cl.exe /c /nologo /Ox /MD /W3 /GS- /DNDEBUG -DMODULE_NAM
> E=\"pysqlite2.dbapi2\" -DSQLITE_OMIT_LOAD_EXTENSION=1 -IC:\python27\include -IC:\Users\rptlab\tmp\tenv\PC /Tcsrc/
> module.c /Fobuild\temp.win-amd64-2.7\Release\src/module.obj
> module.c
>
> c:\users\rptlab\tmp\tmcallister\build\pysqlite\src\connection.h(33) : fatal error C1083: Cannot open include file: 'sqli
> te3.h': No such file or directory
>
> error: command 'c:\\Program Files (x86)\\Microsoft Visual Studio 9.0\\VC\\BIN\\amd64\\cl.exe' failed with exit status 2
>
> ----------------------------------------
> Cleaning up...


I do have the various compilers installed and other extensions are building OK, 
so is this an error in pysqlite or in my general setup? The include path looks 
like it might relate to Python builds. I suppose it's feasible that pyqslite 
builds need to be installed specially. I don't remember this happening on my old 
win32 XP system, but that died and I now am forced to use 64bit win7.
--
Robin Becker