Re: [sqlite] ChangePassword method problem

2011-10-31 Thread Joe Mistachkin
Reading your code quickly, it seems the problem may be related to the use of single-quotes (') around the passwords in the connection string. Please remove all the single-quotes and try again. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] ChangePassword method problem

2011-10-30 Thread Farhan Husain
, sqlite-netFx40-binary-bundle-Win32-2010-1.0.76.0 Thanks.. From: cooljac...@hotmail.com To: sqlite-users@sqlite.org Date: Mon, 24 Oct 2011 03:55:03 + Subject: Re: [sqlite] ChangePassword method problem Sorry, I should clarify, I meant the chances of the database corruption. You are right

Re: [sqlite] ChangePassword method problem

2011-10-23 Thread Joe Mistachkin
Farhan Husain wrote: Aah, ok. So, for all the methods that act on the database I should explicitly add conn.Close() within the using conn scope? Well, I'm not familiar with your specific project; however, that does not sound like a bad idea. -- Joe Mistachkin

Re: [sqlite] ChangePassword method problem

2011-10-23 Thread Farhan Husain
: [sqlite] ChangePassword method problem Farhan Husain wrote: Aah, ok. So, for all the methods that act on the database I should explicitly add conn.Close() within the using conn scope? Well, I'm not familiar with your specific project; however, that does not sound like a bad idea

Re: [sqlite] ChangePassword method problem

2011-10-23 Thread Simon Slavin
On 24 Oct 2011, at 4:42am, Farhan Husain wrote: So, I was just wondering how you would deal with multiple processes accessing the database. You can't guarantee that all would be closing the connection properly. It would seem that if all connections needed to be closed before a proper

Re: [sqlite] ChangePassword method problem

2011-10-23 Thread Farhan Husain
sure it is simply something that I am doing wrong on my end so I need to revisit all the codepaths for this procedure in my code. Thanks! From: slav...@bigfraud.org Date: Mon, 24 Oct 2011 04:45:24 +0100 To: sqlite-users@sqlite.org Subject: Re: [sqlite] ChangePassword method problem On 24

[sqlite] ChangePassword method problem

2011-10-22 Thread Farhan Husain
Hi, I just want to make sure that I am not doing something wrong, but I have a simple application that opens an encrypted database using it's password and calls the ChangePassword method on it (as shown on numerous posts in this forum). After the password is changed when I try to open the

Re: [sqlite] ChangePassword method problem

2011-10-22 Thread Joe Mistachkin
Farhan Husain wrote: After the password is changed when I try to open the database again, I get the File is not... error, as though you are opening an encrypted database with the wrong password. Before you tried to open the database again, did you call the SetPassword method on that

Re: [sqlite] ChangePassword method problem

2011-10-22 Thread Farhan Husain
and win7) just to make sure it had nothing to do with the development machine. From: sql...@mistachkin.com To: sqlite-users@sqlite.org Date: Sat, 22 Oct 2011 19:38:58 -0700 Subject: Re: [sqlite] ChangePassword method problem Farhan Husain wrote: After the password is changed when I try

Re: [sqlite] ChangePassword method problem

2011-10-22 Thread Joe Mistachkin
Farhan Husain wrote: I have tried opening all encrypted databases using both the SetPassword method and the password property in the connection string. No matter what combination I use, after the password is changed using ChangePassword method, the database becomes unreadable using the

Re: [sqlite] ChangePassword method problem

2011-10-22 Thread Farhan Husain
something wrong with the coding but at this point I am not sure. From: sql...@mistachkin.com To: sqlite-users@sqlite.org Date: Sat, 22 Oct 2011 20:39:09 -0700 Subject: Re: [sqlite] ChangePassword method problem Farhan Husain wrote: I have tried opening all encrypted databases using both

Re: [sqlite] ChangePassword method problem

2011-10-22 Thread Joe Mistachkin
One thing that could be a potential issue here is that all connections must be closed prior to changing the password on the database [except the connection used for the ChangePassword method call itself]. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] ChangePassword method problem

2011-10-22 Thread Farhan Husain
Aah, ok. So, for all the methods that act on the database I should explicitly add conn.Close() within the using conn scope? From: sql...@mistachkin.com To: sqlite-users@sqlite.org Date: Sat, 22 Oct 2011 22:04:33 -0700 Subject: Re: [sqlite] ChangePassword method problem One thing