On Fri, Jul 1, 2011 at 2:24 PM, Steve Baugh <stephen.bau...@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.bau...@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.bau...@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@python.org >> > >> > http://mail.python.org/mailman/listinfo/ironpython-users >> > >> > >> > > >> > > >> > > >> >> > > > _______________________________________________ Ironpython-users mailing list Ironpython-users@python.org http://mail.python.org/mailman/listinfo/ironpython-users
