Setting up a Networked Database?

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

2 messages

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

2 total messages Started by Scott Kent-Collins Tue, 04 Jul 2000 00:00

#1024

Author: Scott Kent-Collins
Date: Tue, 04 Jul 2000 00:00

27 lines
1635 bytes

How would I setup a couple of Database Applications to access the same
Database over a network.

The setup is like this:

The Database resides on one machine (Server).

The 1st Application (App1) can reside on the Server or one another machine
on the network(Client), and remains running and writes information to the
Database upon user input.

The 2nd Application (App2) can reside on the Server or on a Client, and it
monitors the data being entered by App1.  App2 uses a number of querries on
multiple Tables from the Database and it updates every 3-5 secs.

The Applications work fine when both run on the same machine with the
Database on that same machine aswell (i.e. not over a network), but how can
I get App2 to monitor and display the data being entered by App1 over a
network?  The only way I have found to get it working is to Disconnect and
Reconnect the Database components in App2 every time it updates, but this
causes flickering in my display grids (which are displaying the query
results).

Thankyou in advance for any help.

Scott Kent-Collins
scott.kent-collins@quest.com.au

Re: Setting up a Networked Database?

#1038

Author: Jan Karpisek
Date: Tue, 11 Jul 2000 00:00

6 lines
748 bytes

Hi,
I suppose you are using file-based database like Paradox.
If you move to RDBMS like InterBase or Oracle you can see
the commited changes made by other user even over network.

Jan

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