Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 8 of 8 total |
Encrypted Table Weirdness |
Mon, May 29 2006 12:40 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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. =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 PM | Permanent 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 PM | Permanent 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. =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 PM | Permanent 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. > > =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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |