[Ironpython-users] SQLite3

[Jeff Hardy]

On Fri, Jul 1, 2011 at 2:24 PM, Steve Baugh <stephen.baugh1 at ntlworld.com> wrote:
> Jeff,
>
> Thank you for doing the updated file. I have downloaded it.
>
> I have got it working but the plot thickens!
>
> I put the new IronPython.SQLite.dll + sqlite3.dll into the DLLs
> directory.
> Doing import sqlite3 gave the _sqlite3 not found error.
> I then put a copy of the dll in the same directory as ipy64.exe so it
> was on the path, then started ipy64.exe by double clicking the file (if
> you start it through the Start Menu the path isn't right).
> after import clr and clr.AddReference("IronPython.SQLite")
> I could then import sqlite3 correctly.
>
> So this seems OK except that it did not automatically add the reference
> by putting it in the DLLs directory.

That's odd. I'll have to look into what's going on there.

>
> I then tried to get things going under SharpDevelop,
> after a lot of experiment I found that I had to put the dll and the
> sqlite3 directory in
> \Program Files (x86)\SharpDevelop\4.0\AddIns\BackendBindings
> \PythonBinding
>
> I could then add the reference but got _sqlite3 not found again.
>
> I found eventually that the version ID of the SharpDevelop
> IronPython.dll is 2.6.1008.2 whilst the IronPython 2.7 distribution is
> 2.7.0.40
>
> So I then put the OLD dll in THIS directory (I still had a copy) and
> things then started to work through the IDE!

Makes sense, if SharpDevelop still embeds 2.6.

> BTW do I need sqlite3.dll as well?

Nope. IronPython.Sqlite uses the csharp-sqlite library
(http://code.google.com/p/csharp-sqlite/) so it doesn't depend on
native code at all.

- Jeff


>
> Thanks
>
> Steve
>
>
> On Fri, 2011-07-01 at 01:49 +0100, Steve Baugh wrote:
>> Thanks Jeff,
>>
>> I will try it soon,
>>
>> Steve
>>
>> On Wed, 2011-06-29 at 21:00 -0700, Jeff Hardy wrote:
>> > 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
>> > >> >
>> > >
>> > >
>> > >
>>
>>
>
>
>