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

Re: [sqlite] ChangePassword method problem

2011-10-30 Thread Farhan Husain
tly so I kept it simple just 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] ChangePasswo

Re: [sqlite] ChangePassword method problem

2011-10-23 Thread Farhan Husain
ain, 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] Ch

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 c

Re: [sqlite] ChangePassword method problem

2011-10-23 Thread Farhan Husain
:05 -0700 > 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 no

Re: [sqlite] ChangePassword method problem

2011-10-22 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 list

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 u

Re: [sqlite] ChangePassword method problem

2011-10-22 Thread Farhan Husain
winxp 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

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