[Ironpython-users] SQLite3

[Jeff Hardy]

Hi Steve,
Please download a new copy of the file. The old one was built against
a beta version of IronPython 2.7. It works in my quick testing.

- Jeff

On Wed, Jun 29, 2011 at 8:00 PM, Steve Baugh
<stephen.baugh1 at ntlworld.com> wrote:
>
> 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
>> >
>
>
>