Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread Encrypted Table Weirdness
Mon, May 29 2006 12:40 PMPermanent Link

Norman L. Kleinberg
I'm just throwing this out there. I know it's something simple that will be perfectly
clear in retrospect but RIGHT NOW I can't figure it out.

I'm using Engine Version 3.3 in Delphi 5 Enterprise. I have many modules in a suite that
use two encrypted tables. I always have a DBISAMDatabase in the project, no DBISAMSession
(use the default) and the two tables use the Database. In the FormCreate I assign the
Directory Name to the Database and proceed to open the tables. Immediately before opening
the tables I do a Session.AddPassword and the tables open fine. In this ONE project the
Session.AddPassword doesn't (seem to) work. No matter what I do, no matter how close to
the beginning of FormCreate I place the code, immediately upon executing Table.Open I get
the Password Dialog.

I've checked the Directory just before the open and it's correct. The passwords are
correct. I've created a simple project with just a Database and (encrypted) table and the
AddPassword works fine, the table opens without the assistance of the Password Dialog. I
KNOW it's something in that module (order of Uses Clause or Creation Order, maybe?) but I
was hoping someone else had a similar experience and might give me a pointer or two.

Thanks in advance.

=NLK=
Mon, May 29 2006 1:14 PMPermanent Link

"Walter Matte"
Try assigning Password in the DBISAMDatabase.BeforeConnect event.

If you have a Table or Query automatically opening... you will be sure to
set password and directory properly through this event.

Walter


"Norman L. Kleinberg" <nlk11021@yahoo.com> wrote in message
news:CCF00874-CD4C-40EB-BB0D-B33CDC7E62B9@news.elevatesoft.com...
> I'm just throwing this out there. I know it's something simple that will
> be perfectly
> clear in retrospect but RIGHT NOW I can't figure it out.
>
> I'm using Engine Version 3.3 in Delphi 5 Enterprise. I have many modules
> in a suite that
> use two encrypted tables. I always have a DBISAMDatabase in the project,
> no DBISAMSession
> (use the default) and the two tables use the Database. In the FormCreate I
> assign the
> Directory Name to the Database and proceed to open the tables. Immediately
> before opening
> the tables I do a Session.AddPassword and the tables open fine. In this
> ONE project the
> Session.AddPassword doesn't (seem to) work. No matter what I do, no matter
> how close to
> the beginning of FormCreate I place the code, immediately upon executing
> Table.Open I get
> the Password Dialog.
>
> I've checked the Directory just before the open and it's correct. The
> passwords are
> correct. I've created a simple project with just a Database and
> (encrypted) table and the
> AddPassword works fine, the table opens without the assistance of the
> Password Dialog. I
> KNOW it's something in that module (order of Uses Clause or Creation
> Order, maybe?) but I
> was hoping someone else had a similar experience and might give me a
> pointer or two.
>
> Thanks in advance.
>
> =NLK=
>

Mon, May 29 2006 5:58 PMPermanent Link

Norman L. Kleinberg
Thanks, Walter, for taking the time to try to help me out.

Unfortunately, no go. Still get the prompt.

Boy, when I find out what's actually going wrong I'm going to feel like a REAL dummy.
Funny thing is, usually the epiphany occurs right after I post my first message asking for
help. Too bad that strategy didn't work this time. Smile

=NLK=


"Walter Matte" <walter_@_interlog.com> wrote:

Try assigning Password in the DBISAMDatabase.BeforeConnect event.

If you have a Table or Query automatically opening... you will be sure to
set password and directory properly through this event.

Walter


"Norman L. Kleinberg" <nlk11021@yahoo.com> wrote in message
news:CCF00874-CD4C-40EB-BB0D-B33CDC7E62B9@news.elevatesoft.com...
> I'm just throwing this out there. I know it's something simple that will
> be perfectly
> clear in retrospect but RIGHT NOW I can't figure it out.
>
> I'm using Engine Version 3.3 in Delphi 5 Enterprise. I have many modules
> in a suite that
> use two encrypted tables. I always have a DBISAMDatabase in the project,
> no DBISAMSession
> (use the default) and the two tables use the Database. In the FormCreate I
> assign the
> Directory Name to the Database and proceed to open the tables. Immediately
> before opening
> the tables I do a Session.AddPassword and the tables open fine. In this
> ONE project the
> Session.AddPassword doesn't (seem to) work. No matter what I do, no matter
> how close to
> the beginning of FormCreate I place the code, immediately upon executing
> Table.Open I get
> the Password Dialog.
>
> I've checked the Directory just before the open and it's correct. The
> passwords are
> correct. I've created a simple project with just a Database and
> (encrypted) table and the
> AddPassword works fine, the table opens without the assistance of the
> Password Dialog. I
> KNOW it's something in that module (order of Uses Clause or Creation
> Order, maybe?) but I
> was hoping someone else had a similar experience and might give me a
> pointer or two.
>
> Thanks in advance.
>
> =NLK=
>

Mon, May 29 2006 7:15 PMPermanent Link

"Clive"
The Querys not set to ACTIVE in the Delphi IDE is it?

"Norman L. Kleinberg" <nlk11021@yahoo.com> wrote in message
news:CCF00874-CD4C-40EB-BB0D-B33CDC7E62B9@news.elevatesoft.com...
> I'm just throwing this out there. I know it's something simple that will
> be perfectly
> clear in retrospect but RIGHT NOW I can't figure it out.
>
> I'm using Engine Version 3.3 in Delphi 5 Enterprise. I have many modules
> in a suite that
> use two encrypted tables. I always have a DBISAMDatabase in the project,
> no DBISAMSession
> (use the default) and the two tables use the Database. In the FormCreate I
> assign the
> Directory Name to the Database and proceed to open the tables. Immediately
> before opening
> the tables I do a Session.AddPassword and the tables open fine. In this
> ONE project the
> Session.AddPassword doesn't (seem to) work. No matter what I do, no matter
> how close to
> the beginning of FormCreate I place the code, immediately upon executing
> Table.Open I get
> the Password Dialog.
>
> I've checked the Directory just before the open and it's correct. The
> passwords are
> correct. I've created a simple project with just a Database and
> (encrypted) table and the
> AddPassword works fine, the table opens without the assistance of the
> Password Dialog. I
> KNOW it's something in that module (order of Uses Clause or Creation
> Order, maybe?) but I
> was hoping someone else had a similar experience and might give me a
> pointer or two.
>
> Thanks in advance.
>
> =NLK=
>

Mon, May 29 2006 7:38 PMPermanent Link

Norman L. Kleinberg
Clive:

Thanks for the post.

There are no queries in the project. Just one form with six tables, some LookUp combos and
an RBuilder report.

I had to put a TDBISAMSession component on the form and use a non-default session. It now
works. Why, I do not know but I don't have time to worry about it right now.

So thanks to both of you who replied, appreciate the advice, but some things are
unknowable. Smile

=NLK=


"Clive" <dd@dddd.com> wrote:

The Querys not set to ACTIVE in the Delphi IDE is it?

"Norman L. Kleinberg" <nlk11021@yahoo.com> wrote in message
news:CCF00874-CD4C-40EB-BB0D-B33CDC7E62B9@news.elevatesoft.com...
> I'm just throwing this out there. I know it's something simple that will
> be perfectly
> clear in retrospect but RIGHT NOW I can't figure it out.
>
> I'm using Engine Version 3.3 in Delphi 5 Enterprise. I have many modules
> in a suite that
> use two encrypted tables. I always have a DBISAMDatabase in the project,
> no DBISAMSession
> (use the default) and the two tables use the Database. In the FormCreate I
> assign the
> Directory Name to the Database and proceed to open the tables. Immediately
> before opening
> the tables I do a Session.AddPassword and the tables open fine. In this
> ONE project the
> Session.AddPassword doesn't (seem to) work. No matter what I do, no matter
> how close to
> the beginning of FormCreate I place the code, immediately upon executing
> Table.Open I get
> the Password Dialog.
>
> I've checked the Directory just before the open and it's correct. The
> passwords are
> correct. I've created a simple project with just a Database and
> (encrypted) table and the
> AddPassword works fine, the table opens without the assistance of the
> Password Dialog. I
> KNOW it's something in that module (order of Uses Clause or Creation
> Order, maybe?) but I
> was hoping someone else had a similar experience and might give me a
> pointer or two.
>
> Thanks in advance.
>
> =NLK=
>

Mon, May 29 2006 7:43 PMPermanent Link

"Clive"
Sounds like to me that the Table was left in an Active state in Delphi IDE.

Anyway, glad your ok now

thanks
Clive.

"Norman L. Kleinberg" <nlk11021@yahoo.com> wrote in message
news:65462D1B-348E-4C0E-9C56-6A5CE46A3081@news.elevatesoft.com...
> Clive:
>
> Thanks for the post.
>
> There are no queries in the project. Just one form with six tables, some
> LookUp combos and
> an RBuilder report.
>
> I had to put a TDBISAMSession component on the form and use a non-default
> session. It now
> works. Why, I do not know but I don't have time to worry about it right
> now.
>
> So thanks to both of you who replied, appreciate the advice, but some
> things are
> unknowable. Smile
>
> =NLK=
>
>
> "Clive" <dd@dddd.com> wrote:
>
> The Querys not set to ACTIVE in the Delphi IDE is it?
>
> "Norman L. Kleinberg" <nlk11021@yahoo.com> wrote in message
> news:CCF00874-CD4C-40EB-BB0D-B33CDC7E62B9@news.elevatesoft.com...
>> I'm just throwing this out there. I know it's something simple that will
>> be perfectly
>> clear in retrospect but RIGHT NOW I can't figure it out.
>>
>> I'm using Engine Version 3.3 in Delphi 5 Enterprise. I have many modules
>> in a suite that
>> use two encrypted tables. I always have a DBISAMDatabase in the project,
>> no DBISAMSession
>> (use the default) and the two tables use the Database. In the FormCreate
>> I
>> assign the
>> Directory Name to the Database and proceed to open the tables.
>> Immediately
>> before opening
>> the tables I do a Session.AddPassword and the tables open fine. In this
>> ONE project the
>> Session.AddPassword doesn't (seem to) work. No matter what I do, no
>> matter
>> how close to
>> the beginning of FormCreate I place the code, immediately upon executing
>> Table.Open I get
>> the Password Dialog.
>>
>> I've checked the Directory just before the open and it's correct. The
>> passwords are
>> correct. I've created a simple project with just a Database and
>> (encrypted) table and the
>> AddPassword works fine, the table opens without the assistance of the
>> Password Dialog. I
>> KNOW it's something in that module (order of Uses Clause or Creation
>> Order, maybe?) but I
>> was hoping someone else had a similar experience and might give me a
>> pointer or two.
>>
>> Thanks in advance.
>>
>> =NLK=
>>
>
>

Tue, May 30 2006 9:03 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Norman,

<< I had to put a TDBISAMSession component on the form and use a non-default
session. It now works. Why, I do not know but I don't have time to worry
about it right now. >>

If you remove the new session and revert everything back to the default
session and it works, then the problem was probably what Clive stated - you
had something left open at design-time in the IDE that wasn't using your
TDBISAMDatabase component because the DatabaseName was either empty or set
directly to the database path.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, May 30 2006 5:15 PMPermanent Link

Norman L. Kleinberg
Clive, Tim:

Appreciate the help. I really don't know if I'll have time to test your idea out but I'm
sure you guys know your stuff; I'll file all this away for future reference.
In any case, it's comforting to know that that there a great support community for DBISAM
out there.

=NLK=

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Norman,

<< I had to put a TDBISAMSession component on the form and use a non-default
session. It now works. Why, I do not know but I don't have time to worry
about it right now. >>

If you remove the new session and revert everything back to the default
session and it works, then the problem was probably what Clive stated - you
had something left open at design-time in the IDE that wasn't using your
TDBISAMDatabase component because the DatabaseName was either empty or set
directly to the database path.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image