Re: [sqlite] upgrading DB from 3.6.23 to 3.7.5

2011-02-11 Thread Sam Carleton 
Ok, it looks like it is my environment, I just created a little .Net test
program and it worked fine.  Maybe I have the other process running already,
though I didn't think that was the case.  I am off to do some more digging.

On Fri, Feb 11, 2011 at 9:14 AM, Dan Kennedy  wrote:

> On 02/11/2011 08:08 PM, Sam Carleton wrote:
> > On Fri, Feb 11, 2011 at 6:54 AM, Philip Graham Willoughby<
> > phil.willoug...@strawberrycat.com>  wrote:
> >
> >> Hi Sam,
> >>
> >> On 11 Feb 2011, at 05:29, Sam Carleton wrote:
> >>> I am sure it is bad form, but attached is one of the 3.6.23 DB, it is
> >> only
> >>> 12K.
> >>
> >> The mailing list software strips attachments; can you share it on
> dropbox
> >> (free account here: http://www.dropbox.com/referrals/NTEwMzQxNDc1OQ )
> or
> >> some similar service?
> >>
> >
> > dropbox is very handy, but I don't like now their public share does NOT
> have
> > a web page front end, it is just a link that start downloading the file.
> > Here is a link to the file via yousendit.com, it has a bit nicer
> > presentation:)  Thanks for the help!
> >
> > https://www.yousendit.com/download/MzZHT213TXZtUUh2Wmc9PQ
>
> This database works fine with 3.7.5 here. What error are you
> getting?
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] upgrading DB from 3.6.23 to 3.7.5

2011-02-11 Thread Dan Kennedy 
On 02/11/2011 08:08 PM, Sam Carleton wrote:
> On Fri, Feb 11, 2011 at 6:54 AM, Philip Graham Willoughby<
> phil.willoug...@strawberrycat.com>  wrote:
>
>> Hi Sam,
>>
>> On 11 Feb 2011, at 05:29, Sam Carleton wrote:
>>> I am sure it is bad form, but attached is one of the 3.6.23 DB, it is
>> only
>>> 12K.
>>
>> The mailing list software strips attachments; can you share it on dropbox
>> (free account here: http://www.dropbox.com/referrals/NTEwMzQxNDc1OQ ) or
>> some similar service?
>>
>
> dropbox is very handy, but I don't like now their public share does NOT have
> a web page front end, it is just a link that start downloading the file.
> Here is a link to the file via yousendit.com, it has a bit nicer
> presentation:)  Thanks for the help!
>
> https://www.yousendit.com/download/MzZHT213TXZtUUh2Wmc9PQ

This database works fine with 3.7.5 here. What error are you
getting?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] upgrading DB from 3.6.23 to 3.7.5

2011-02-11 Thread Sam Carleton 
On Fri, Feb 11, 2011 at 6:54 AM, Philip Graham Willoughby <
phil.willoug...@strawberrycat.com> wrote:

> Hi Sam,
>
> On 11 Feb 2011, at 05:29, Sam Carleton wrote:
> > I am sure it is bad form, but attached is one of the 3.6.23 DB, it is
> only
> > 12K.
>
> The mailing list software strips attachments; can you share it on dropbox
> (free account here: http://www.dropbox.com/referrals/NTEwMzQxNDc1OQ ) or
> some similar service?
>

dropbox is very handy, but I don't like now their public share does NOT have
a web page front end, it is just a link that start downloading the file.
Here is a link to the file via yousendit.com, it has a bit nicer
presentation:)  Thanks for the help!

https://www.yousendit.com/download/MzZHT213TXZtUUh2Wmc9PQ

File expiration date: *permanently* *February 18, 2011*

Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] upgrading DB from 3.6.23 to 3.7.5

2011-02-11 Thread Philip Graham Willoughby 
Hi Sam,

On 11 Feb 2011, at 05:29, Sam Carleton wrote:
> I am sure it is bad form, but attached is one of the 3.6.23 DB, it is only
> 12K.

The mailing list software strips attachments; can you share it on dropbox (free 
account here: http://www.dropbox.com/referrals/NTEwMzQxNDc1OQ ) or some similar 
service?

Best Regards,

Phil Willoughby
-- 
Managing Director, StrawberryCat Limited

StrawberryCat Limited is registered in England and Wales with Company No. 
7234809.

The registered office address of StrawberryCat Limited is:

107 Morgan Le Fay Drive
Eastleigh
SO53 4JH

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] upgrading DB from 3.6.23 to 3.7.5

2011-02-10 Thread Sam Carleton 
I am in the process of upgrading my app from using SQLite.net w/ 3.6.23 to
SQLite.net w/ 3.7.5.  When the .Net program starts in a fresh install state,
aka no system db exists and it builds one up via SQL script all works fine.
When it opens an existing 3.6.23 system db, it gets a database lock. and
fails.  But when I open it from the sqlite.exe compiled with 3.7.5, it opens
fine.

Generally speaking, how do I convert the 3.6.23 db to 3.7.5?

I am sure it is bad form, but attached is one of the 3.6.23 DB, it is only
12K.

Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users