sqlite db password?

Earthednet-wp prothero at earthednet.org
Fri Feb 12 07:59:36 CET 2016


My SQLite db was created about 6-7yrs ago, so password protection has probably changed since then. My best option may be to open up director 10 on an old os and reset or turn off the password. Perhaps I can avoid the whole problem by going back to content created before I put it into a db in the first place. My need isn't immediate, but I thought it might be easy. If nobody has a brilliant idea, I'll put this on hold for now.
Best,
Bill

William Prothero
http://es.earthednet.org

> On Feb 11, 2016, at 9:39 PM, Earthednet-wp <prothero at earthednet.org> wrote:
> 
> Peter,
> Thanks so much! I can probably do it if you point me in the right direction. I found the command line tool and I'll see if I can use it. I may not get to it until Monday. Going to be out of town until then.
> 
> This may be the direction I need, tho.
> Best,
> Bill
> 
> William Prothero
> http://es.earthednet.org
> 
>> On Feb 11, 2016, at 5:06 PM, Peter Haworth <pete at lcsql.com> wrote:
>> 
>> Hi Bill,
>> SQLite didn't have built-in password protection until a fairly recent
>> release and the SQLite library.  I dont recall which version.  The SQLite
>> library included with Livecode 8 is a fairly recent one and I believe
>> includes the password feature
>> 
>> Unfortunately, Livecode has not been updated to include the necessary
>> parameters to revOpenDatabase to pass in a password for sqlite, as you've
>> found. If you know the password, you can remove it using the sqlite3
>> command line tool but I'd have to reserach that further for you.
>> 
>> Pete
>> 
>> On Thu, Feb 11, 2016 at 4:37 PM William Prothero <prothero at earthednet.org>
>> wrote:
>> 
>>> Folks:
>>> 
>>> I have an sqlite database created in Adobe Director using an old Xtra
>>> (Arca). It has a password. Can livecode open an sqlite database that is
>>> password protected? I can’t tell from the dictionary, how to open a
>>> password protected db that is local.
>>> 
>>> Thanks for any info.
>>> Best,
>>> Bill
>>> 
>>> 
>>> William Prothero, Ph.D.
>>> University of California, Santa Barbara, Emeritus
>>> prothero at earthednet.org
>>> 
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the use-livecode mailing list