Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread TDBISAMDatabase and shared TDBISAMSession
Wed, Jun 4 2008 2:50 AMPermanent 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 PMPermanent Link

Steve Forbes

Team Elevate 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 PMPermanent 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 PMPermanent Link

Steve Forbes

Team Elevate 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 PMPermanent 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 PMPermanent Link

Steve Forbes

Team Elevate 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
>

Image