Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
TDBISAMDatabase and shared TDBISAMSession |
Wed, Jun 4 2008 2:50 AM | Permanent Link |
"JohnE" | I've combed old posts looking for this, and couldn't find anything.
I have a TDBISAMSession component that I share between multiple forms called 'MainRemote'. MainRemote is a TSessiontype = stRemote, and TRemoteType = rtInternet. All of the application tables use MainRemote directly. One form uses a TDBISAMDatabase component, called OrderDatabase, so that its tables can utilize transactions. I set the OrderDatabase sessionname to 'MainRemote', and all hell breaks loose. The ValidateName of the OrderDatabase reports a 'EDatabaseError with message 'Database name Ordermgr already exists.' Ordermgr is one of my database names configured within the server manager, and utilized throughout the application. If I iterate the MainSession.Database property prior to attempting to set the OrderDatabase.Sessionname property, there are no databases present. DBISAM 3.26 CS. TIA, John |
Wed, Jun 4 2008 7:22 PM | Permanent Link |
Steve Forbes Team Elevate | Hi John,
Probably a silly question, but does your OrderDatabase have its DatabaseName property have a value? -- Best Regards Steve [Team Elevate] "JohnE" <Kidding@Serio.us> wrote in message news:247DFAAD-9F67-4A3D-B7D7-02226539DA4E@news.elevatesoft.com... > I've combed old posts looking for this, and couldn't find anything. > > I have a TDBISAMSession component that I share between multiple forms > called 'MainRemote'. MainRemote is a TSessiontype = stRemote, and > TRemoteType = rtInternet. > > All of the application tables use MainRemote directly. One form uses a > TDBISAMDatabase component, called OrderDatabase, so that its tables can > utilize transactions. I set the OrderDatabase sessionname to 'MainRemote', > and all hell breaks loose. The ValidateName of the OrderDatabase reports > a 'EDatabaseError with message 'Database name Ordermgr already exists.' > > Ordermgr is one of my database names configured within the server manager, > and utilized throughout the application. If I iterate the > MainSession.Database property prior to attempting to set the > OrderDatabase.Sessionname property, there are no databases present. > > DBISAM 3.26 CS. > > TIA, > > John > |
Wed, Jun 4 2008 8:36 PM | Permanent Link |
"JohnE" | > Probably a silly question, but does your OrderDatabase have its
> DatabaseName property have a value? Yes, it's 'Ordermgr' John |
Wed, Jun 4 2008 11:28 PM | Permanent Link |
Steve Forbes Team Elevate | Hi John,
Change the DatabaseName value in the OrderDatabase component to something else, .. as the error says, you already have a TDBISAMDatabase in the application with 'Ordermgr' as the DatabaseName. Good luck. -- Steve [Team Elevate] "JohnE" <Kidding@Serio.us> wrote in message news:5F470250-E24D-4E4C-8A80-121BB1A273DA@news.elevatesoft.com... >> Probably a silly question, but does your OrderDatabase have its >> DatabaseName property have a value? > > > Yes, it's 'Ordermgr' > > John > |
Thu, Jun 5 2008 12:20 PM | Permanent Link |
"JohnE" | > Change the DatabaseName value in the OrderDatabase component to something
> else, .. as the error says, you already have a TDBISAMDatabase in the > application with 'Ordermgr' as the DatabaseName. But, Ordermgr is the database on the server that I want to connect to. I really don't want to have to create a new database each time I drop a TDBISAMDatabase component on my form. Am I missing something? John |
Thu, Jun 5 2008 5:55 PM | Permanent Link |
Steve Forbes Team Elevate | Hi John,
The DatabaseName has nothing to do with the data location etc., it is simply the 'alias' for the component and is used when attaching Query and Table components (i.e. by setting their DatabaseName & Session properties). The DatabaseName property of the TDBISAMDatabase has to be unique within an application. The location of the data is determined by the Directory property. HTH -- Best Regards Steve [Team Elevate] "JohnE" <Kidding@Serio.us> wrote in message news:3F97974B-363F-42A3-932D-0C7AD521D370@news.elevatesoft.com... >> Change the DatabaseName value in the OrderDatabase component to something >> else, .. as the error says, you already have a TDBISAMDatabase in the >> application with 'Ordermgr' as the DatabaseName. > > > But, Ordermgr is the database on the server that I want to connect to. I > really don't want to have to create a new database each time I drop a > TDBISAMDatabase component on my form. > > Am I missing something? > > John > |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |