sqlite db password?

Earthednet-wp prothero at earthednet.org
Fri Feb 12 00:39:10 EST 2016


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




More information about the Use-livecode mailing list