[MonoTouch] SPAM-LOW: Re: Your sqlite3 version is old - please upgrade to at least v3.5.0!
Jonathan Pryor
jonpryor at vt.edu
Mon Oct 26 10:51:10 EDT 2009
So, after tons of debugging, we think we know part of the problem.
You're on the wrong operating system.
It works for me because I'm on Snow Leopard (10.6). It appears to fail
for Simon because he's on Leopard (10.5).
BUT, here's where it gets funny:
$ nm /Developer/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator3.1.2.sdk/usr/lib/libsqlite3.dylib | grep _next
0000c5a0 T _sqlite3_next_stmt
That should be the same everywhere (it's part of the SDK, not the OS).
So what appears to be the problem is that when running within the
simulator, instead of picking up the libsqlite3.dylib provided by
iPhoneSimulator.platform, it instead picks up /usr/lib/libsqlite3.dylib.
Snow Leopard's libsqlite3.dylib is a more recent version than Leopard's
(and Snow Leopard's apparently better matches what's on the device),
which is why it works on both Snow Leopard Simulator & the device.
What I don't know is the solution for Leopard -- how do we get Mono
within the simulator to pick up iPhoneSimulator's libsqlite3.dylib
instead of /usr/lib/libsqlite3.dylib? This will require additional
investigation.
- Jon
On Mon, 2009-10-26 at 21:55 +1100, Ali Shafai wrote:
> ?ui=2&view=att&th=124907be3c8a79b6&attid=0.1&disp=attd&realattid=ii_124907be3c8a79b6&zw
>
> 2009/10/26 Craig Dunn <craig.dunn at conceptdevelopment.net>
> Good news Jonathan - after a bit of fiddling with the 'unused'
> mainwindowxib and adding the correct references I got the
> following output (on simulator) from the sample
> at http://monotouch.net/Documentation/System.Data
>
>
> (Row (PersonID '1') (FirstName 'First') (LastName 'Last'))
> (Row (PersonID '2') (FirstName 'Dewey') (LastName 'Cheatem'))
> (Row (PersonID '3') (FirstName 'And') (LastName 'How'))
>
>
>
>
> I also added it to another sample, just to be sure
> http://conceptdev.blogspot.com/2009/10/monotouch-corp411-part-iii-revenge-of.html
>
>
> craig
>
>
> p.s. excuse the dup post - there is another 'answer' in the
> ether with a too-large attachment...
>
>
>
>
>
> On Mon, Oct 26, 2009 at 1:23 PM, Jonathan Pryor
> <jonpryor at vt.edu> wrote:
>
> So I'm terribly confused. Apparently the sample code
> works for me, but not for anyone else. :-/
>
>
> As a last-ditch effort at reproducibility, I've
> updated the monocatalog-md sample to use
> Mono.Data.Sqlite:
>
>
> http://anonsvn.mono-project.com/source/trunk/monotouch/samples/monocatalog-md/
>
>
> Specifically:
>
>
> http://anonsvn.mono-project.com/source/trunk/monotouch/samples/monocatalog-md/MonoDataSqlite.xib.cs
>
>
> That sample works for me, without error, on both the
> simulator and the device. Does this work for anyone
> else?
>
>
> Thanks,
> - Jon
>
>
> On Oct 25, 2009, at 6:24 PM, Ali Shafai wrote:
>
>
>
> > it was actually exactly that example that gave me
> > the error. I ran on simulator only. don't have
> > access to my mac at work. to test on device I have
> > to wait for another 8 hours :(
> >
> > Cheers,
> > Ali
> >
> > 2009/10/26 Simon Guindon <simon at nureality.ca>
> > I ran this on the simulator first and that's
> > the result I got. I'll run on device and let
> > you know the results.
> >
> >
> > I'll give the example a run as well.
> >
> >
> > Thanks,
> > Simon
> >
> >
> > ____________________________________________
> > From: jonpryor at vt.edu
> >
> > To: simon at nureality.ca
> >
> > Subject: Re: [MonoTouch] Your sqlite3
> > version is old - please upgrade to at least
> > v3.5.0!
> >
> > Date: Sun, 25 Oct 2009 12:49:48 -0400
> > CC: ali at platysoft.com.au;
> > monotouch at lists.ximian.com
> >
> >
> >
> > Odd. Does the example code at
> > http://monotouch.net/Documentation/System.Data#Example work for you?
> >
> >
> > Which iPhoneOS version & hardware is this?
> >
> >
> > Thanks,
> > - Jon
> >
> > On Oct 25, 2009, at 12:01 PM, Simon Guindon
> > <simon at nureality.ca> wrote:
> >
> >
> >
> > I'm also getting this error.
> >
> >
> > I don't think it's related to using
> > a function that isn't in 3.0 because
> > I'm getting this exception on the
> > connection.Open()
> >
> >
> > I'm doing the following:
> >
> >
> > SqliteConnection.CreateFile(dbPath);
> > SqliteConnection connection = new
> > SqliteConnection("Data Source=" +
> > dbPath);
> > connection.Open();
> >
> >
> > Thanks,
> > Simon
> >
> > > From: jonpryor at vt.edu
> > > To: Ali at PlatySoft.com.au
> > > Date: Sun, 25 Oct 2009 08:26:22
> > -0400
> > > CC: monotouch at lists.ximian.com
> > > Subject: Re: [MonoTouch] Your
> > sqlite3 version is old - please
> > upgrade to at least v3.5.0!
> > >
> > > On Sun, 2009-10-25 at 19:07 +1100,
> > Ali Shafai wrote:
> > > > I'm trying to use Sqlite in my
> > app using the lib from here :
> > > >
> > http://monotouch.net/Documentation/System.Data
> > > >
> > > > when I run my app I get this
> > error: Your sqlite3 version is old -
> > > > please upgrade to at least
> > v3.5.0!
> > >
> > > Can you provide source code that
> > demonstrates this bug?
> > >
> > > Also keep in mind the limitations:
> > >
> > >
> > http://monotouch.net/Documentation/System.Data#Mono.Data.Sqlite
> > >
> > > You're probably attempting to use
> > one of the functions that isn't in
> > > SQLite v3.0 (which is what
> > iPhoneOS provides).
> > >
> > > Thanks,
> > >
> > > - Jon
> > >
> > >
> > >
> > _______________________________________________
> > > MonoTouch mailing list
> > > MonoTouch at lists.ximian.com
> > >
> > http://lists.ximian.com/mailman/listinfo/monotouch
> >
> >
> >
> > ____________________________________
> > CDN College or University student?
> > Get Windows 7 for only $39.99 before
> > Jan 3! Buy it now!
> >
> >
> > ____________________________________________
> > Ready for a deal-of-a-lifetime? Find
> > fantastic offers on Windows 7, in one
> > convenient place.
> >
> >
> >
> > --
> > Cheers,
> > Ali
> >
>
>
>
>
> _______________________________________________
> MonoTouch mailing list
> MonoTouch at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/monotouch
>
>
>
>
>
>
> --
> Cheers,
> Ali
>
More information about the MonoTouch
mailing list