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
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
>
&
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
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
> 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
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
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 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
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:
> >
&
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
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:
> >
> &
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
12 matches
Mail list logo