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 <proth...@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 <p...@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 <proth...@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 >>> 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