subject:"sqlite db password\?"

Re: sqlite db password?

2016-02-11 Thread Earthednet-wp

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  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 
> 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
>> proth...@earthednet.org
>> 
>> 
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: sqlite db password?

2016-02-11 Thread Earthednet-wp

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  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  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 
>> 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
>>> proth...@earthednet.org
>>> 
>>> 
>>> 
>>> 
>>> ___
>>> use-livecode mailing list
>>> use-livecode@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: sqlite db password?

2016-02-11 Thread Peter Haworth

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 
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
> proth...@earthednet.org
>
>
>
>
> ___
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

sqlite db password?

2016-02-11 Thread William Prothero

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
proth...@earthednet.org




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: sqlite db password?

Re: sqlite db password?

Re: sqlite db password?

sqlite db password?

4 matches

Site Navigation

Mail list logo

Footer information