Supporting Multiple databases

Thread View: borland.public.cppbuilder.database.multi-tier

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Greg Major Mon, 22 Nov 1999 00:00

#1342

Author: Greg Major
Date: Mon, 22 Nov 1999 00:00

19 lines
1081 bytes

I hope I can explain this correctly.

I need to support multiple databases from the same application server.
What database the user connects to depends upon the user. All databases
are identical. I can support the stateless functionality easily but I
need a way of re-directing the Remote Datasets so the user gets the
results form the correct database.

--
Gregory A. Major
President
Wilderness Software Group, Inc.
165 Front Street
Building A, 5th Floor
Chicopee, MA 01013

(V) 413 594-7717
(F) 413 594-8530
(E) wsg@w-s-g.com

Re: Supporting Multiple databases

#1345

Author: CyberNIK
Date: Tue, 23 Nov 1999 00:00

34 lines
1628 bytes

You can use remote calls to appserver function that reset dataset
properties.
For example, if you have remote data module (RDM) you can define some
appserver
function RDM::reset( int userID ). This func will change, lets say,
RDM->Table->TableName
before any user data operations. Use DCOM to export reset(int) and remote
call it from
client on connect to appserver.

CyberNIK

Greg Major wrote in message <383954AA.F8D7757F@w-s-g.com>...
>I hope I can explain this correctly.
>
>I need to support multiple databases from the same application server.
>What database the user connects to depends upon the user. All databases
>are identical. I can support the stateless functionality easily but I
>need a way of re-directing the Remote Datasets so the user gets the
>results form the correct database.
>
>--
>Gregory A. Major
>President
>Wilderness Software Group, Inc.
>165 Front Street
>Building A, 5th Floor
>Chicopee, MA 01013
>
>(V) 413 594-7717
>(F) 413 594-8530
>(E) wsg@w-s-g.com
>
>

Re: Supporting Multiple databases

#1374

Author: John Graham
Date: Thu, 16 Dec 1999 00:00

40 lines
1872 bytes

Or you can link all of the datasets  on your app. server to a single
TDatabase object and simply change the "DatabaseName" property to point to
the desired database.

CyberNIK wrote:

> You can use remote calls to appserver function that reset dataset
> properties.
> For example, if you have remote data module (RDM) you can define some
> appserver
> function RDM::reset( int userID ). This func will change, lets say,
> RDM->Table->TableName
> before any user data operations. Use DCOM to export reset(int) and remote
> call it from
> client on connect to appserver.
>
> CyberNIK
>
> Greg Major wrote in message <383954AA.F8D7757F@w-s-g.com>...
> >I hope I can explain this correctly.
> >
> >I need to support multiple databases from the same application server.
> >What database the user connects to depends upon the user. All databases
> >are identical. I can support the stateless functionality easily but I
> >need a way of re-directing the Remote Datasets so the user gets the
> >results form the correct database.
> >
> >--
> >Gregory A. Major
> >President
> >Wilderness Software Group, Inc.
> >165 Front Street
> >Building A, 5th Floor
> >Chicopee, MA 01013
> >
> >(V) 413 594-7717
> >(F) 413 594-8530
> >(E) wsg@w-s-g.com
> >
> >

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads