Paradox 5.0 billing-system, needs to work as multi-user system

#1

Hello,

I have a billing-system for paradox 5.0, the programmer
who has made this system is unfortunately deceased.
My question is, is there a posibility that more people
can work on the same database (multi user system)?
When i connect form more than one computer to the database,
the databse crash immediately.

I hope this are enought informations to answer my question.

thank you very much for
you endeavors to assist

Regards
Joerg Widmann

#2

Paradox is a multiuser database if

a) the data is stored on a network
and
b) NET DIR is specified as a network folder in BDE Configuration Utility
( IDAPI Configuration utility)

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Joerg Widmann" <joerg_widmann (AT) gmx (DOT) de> skrev i meddelandet
news:e9565c$3bk$1 (AT) online (DOT) de...

Quote:

Hello,

I have a billing-system for paradox 5.0, the programmer
who has made this system is unfortunately deceased.
My question is, is there a posibility that more people
can work on the same database (multi user system)?
When i connect form more than one computer to the database,
the databse crash immediately.

I hope this are enought informations to answer my question.

thank you very much for
you endeavors to assist

Regards
Joerg Widmann

#3

Bertil Isberg schrieb:

Quote:

Paradox is a multiuser database if

a) the data is stored on a network
and
b) NET DIR is specified as a network folder in BDE Configuration Utility
( IDAPI Configuration utility)

Thank you for the fast answer.
What OS would you recommend for the Network-Server?

The worksations have winXP and win98

Regards
Joerg Widmann

#4

Quote:

The worksations have winXP and win98

And there is the answer, I'd bet.

Are you hosting the data on a win98 computer right now?

You CAN'T. Move the data to a winXP system.

WinXP and Win98 don't play well together with a win98 system hosting the
data.

As well, make sure Local Share in the BDE is set to TRUE.

---------------------------------------------------------
Tony McGuire

#5

If you have Win XP clients, use XP servers.
--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Joerg Widmann" <joerg_widmann (AT) gmx (DOT) de> skrev i meddelandet
news:e95ajb$bhf$1 (AT) online (DOT) de...

Quote:

Bertil Isberg schrieb:
Paradox is a multiuser database if

a) the data is stored on a network
and
b) NET DIR is specified as a network folder in BDE Configuration
Utility
( IDAPI Configuration utility)

Thank you for the fast answer.
What OS would you recommend for the Network-Server?

The worksations have winXP and win98

Regards
Joerg Widmann

#6

Tony McGuire schrieb:

Quote:

The worksations have winXP and win98

And there is the answer, I'd bet.

Are you hosting the data on a win98 computer right now?

You CAN'T. Move the data to a winXP system.

WinXP and Win98 don't play well together with a win98 system hosting the
data.

As well, make sure Local Share in the BDE is set to TRUE.

---------------------------------------------------------
Tony McGuire

Do I have to set Local Share on both, the server and the clinents?
and same question for the NET dir?

Regards
Joerg Widmann

#7

Are you running Paradox on the 'server'?

If so, you must set these settings on all.

Basically, if you are running Paradox on the system, you need to set these
settings on that system.

---------------------------------------------------------
Tony McGuire

#8

While we're at it:

Quote:

1. http://www.thedbcommunity.com/faq/13.htm

2. Oplocks:
A. NT: http://www.tonymcguire.com/oplocks-nt.htm
i. UseOpportunisticLocking should be 0
ii. EnableOplocks should be 0
iii. The rest don't matter
B. Win2K/XP: http://www.tonymcguire.com/oplocks-2000.htm
i. OplocksDisabled should be 1
ii. EnableOplocks should be 0
iii. The rest don't matter
C. Win9x: Control Panel, System applet, Performance tab, File System
button, Troubleshooting tab, CHECK the boxes labeled:
i. "Disable new file sharing and locking semantics."
ii. "Disable write-behind caching for all drives."
iii. On the Hard Disk tab, you may wish to try setting Read-ahead
optimization to None, but I think that should only make a difference
on the server machine.

3. <not relevant here

4. LOCALSHARE (BDE, Configuration tab, Configuration > System > INIT)
must be set to TRUE for all users.

5. Disk caching on Win2K (presumably XP, but I can't check that):
Properties for the drive, Hardware tab, select the disk of interest,
click the Properties button, on the Disk Properties tab, UNcheck the
"Write cache enabled" box if it'll let you.

6. Make sure the machine serving the .DB files isn't being used as a
workstation.

Liz

#9

In addition to what the others have said, it may be that the app was
written in a way that prevents multi-user access. In most cases, Paradox
apps are inherently multi-user, but I've seen a few where, either
through ignorance or intent, an app is written in a way that prevents
multi-user access.

I inherited several apps that prevent multi-user access. Some of them
force or assume that the private directory and the working directory
point to the same directory. Some use the working directory to hold
criteria tables used in queries, with nothing to identify which user is
using which records. Some of the apps have directory paths hard coded in
the application code. Some of them call batch files to perform
required functions and the batch files point to specific directories.

Chances are, though, that you won't have to deal with any of those types
of issues. Unless the deceased programmer was named "Moe".

Joerg Widmann wrote:

Quote:

Hello,

I have a billing-system for paradox 5.0, the programmer
who has made this system is unfortunately deceased.
My question is, is there a posibility that more people
can work on the same database (multi user system)?
When i connect form more than one computer to the database,
the databse crash immediately.

I hope this are enought informations to answer my question.

thank you very much for
you endeavors to assist

Regards
Joerg Widmann

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Paradox 5.0 billing-system, needs to work as multi-user system

comp.databases.paradox comp.databases.paradox

Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 05:09 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 06:08 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 06:25 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 07:51 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 07:52 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 08:02 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 08:18 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 10:56 AM

Re: Paradox 5.0 billing-system, needs to work as multi-user system - 07-13-2006 , 06:36 PM