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
ust to check. Visual Studio 2010, Debug x86, .NET 4.0 Client Profile, 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 > &

Re: [sqlite] ChangePassword method problem

2011-10-23 Thread Farhan Husain
I am quite 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] ChangeP

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
> Subject: Re: [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

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-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 >

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
till doing 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: > > &

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
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: > > > &

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