mercredi 8 juillet 2015

sqlite3 Python library update failed on Windows

I have running on Windows 7 64-bits/Anaconda package for Python 2.7 - I am currently using sqlite3 library via Python. Using:

import sqlite3
print sqlite3.sqlite_version, sqlite3.version

I got '3.6.21, 2.6.0'

I want to upgrade to sqlite3 to 3.8.x so I downloaded the Windows binary '32-bit DLL (x86) for SQLite verison 3.8.10.2.' in SQLiteDownload

I followed the instructions given in oen of the StackOverflow: Thread here

I understood sqlite3 is actually using pysqlite2 module on the background - so I also tried to update this specific via pip or easy_install but it fails on gcc.bat failed with exit status 1

Essentially when updating the sqlite3.dll with the newest, sqlite3 import command now failed:

from _sqlite3 import *
File "C:\Program Files (x86)\JetBrains\PyCharm Community Edition 4.0.4\helpers\pydev\pydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
ImportError: DLL load failed: %1 is not a valid Win32 application.

So my question is: how to I update my python sqlite3 library ?

Thanks, Dylan.

Aucun commentaire:

Enregistrer un commentaire