[Ironpython-users] SQLite3

[Steve Baugh]

Jeff,

Thank you for your reply.

I have downloaded 

IronPython.SQLite-2.7.0_ipy-2.7_clr-v4.0.zip

but can't make it work.

I have put the IronPython.SQLite.dll in the DLLs folder and put the
sqlite3 folder under Lib.

When I try:

import sqlite3

in either ipy or ipy64 I get:

ImportError: No module named _sqlite3

I have put copies of sqlite.dll in both the IronPython 2.7 folder and
the DLLs folder.

When I import clr and try clr.AddReference("IronPython.SQLite") it seems
to add the refrence (when the default path is right) but I still get the
No module named _sqlite3 error with an import statement.

The IronPython 2.7 installed to Program Files (x86) as it is a 64 bit
system. I have also tried with with a Win XP 32 bit system.

I am encouraged that you said it should work, but I seem to be doing
something wrong....

Steve
On Wed, 2011-06-29 at 09:33 -0700, Jeff Hardy wrote:
> You should be able to use IronPython.SQLite
> (https://bitbucket.org/jdhardy/ironpython.sqlite/). There's a
> 2.7-compatible build on the downloads page. It's not 100% compatible
> with CPython sqlite, but it's pretty darn close.
> 
> - Jeff
> 
> On Mon, Jun 27, 2011 at 2:26 PM, Steve Baugh
> <stephen.baugh1 at ntlworld.com> wrote:
> > I am trying to port a Linux Python program to IronPython and WPF. This
> > program makes use of sqlite3. I am not trying to use data aware contols,
> > I just want to issue SQL commands and get the results from SELECT
> > statements.
> >
> > I have been getting conflicting, and in some cases contradictory,
> > information from my web searches.
> >
> > Has anyone done this with IronPython 2.7 on .NET 4? I am am using
> > SharpStudio in Windows 7 64 bit (but I am not trying to build a 64 bit
> > application).
> >
> > Thanks,
> >
> > Steve
> >
> > _______________________________________________
> > Ironpython-users mailing list
> > Ironpython-users at python.org
> > http://mail.python.org/mailman/listinfo/ironpython-users
> >