Technical Notes Database
TN8B.txt What to check when you cannot get an all users int
Category :InterBase
Platform :All
Product :Borland SQL Lin 4.5
Description:
Keywords: IB, interface, connect
Question: I have three users trying to access data on my InterBase server via
Paradox. I can get two users in just fine, but the system refuses
to let me enter a third one.
Answer: There are a number of things that can cause this. First, can you get
all three users into Paradox? If you are not using runtime, you need
a valid license of Paradox for each user. If you cannot get all
users into Paradox, first check to make sure that you have adequate
licenses of Paradox for Windows. If you have adequate licenses of
Paradox, make sure that all users are pointed to the same
pdoxusrs.net file. If you suspect the pdoxusrs.net file may be the
culprit, delete any pdoxusrs.net and the paradox.net files that you
may find, when everyone is out of Paradox. (This is just in case
you may have had a damaged pdoxusrs.net.) If that does
not solve the problem, we will look to possible causes on the server
side.
On the server side, make sure that you have valid UNIX logins for
each user who will be trying to access the data on the InterBase
server. You can use the UNIX command "uname" to do this.
eg. uname -x
Next, run gsec with the -display option to find out if all three
users have access to the remote database. If you find that one of
your users does not have access to the remote database, you will need
to do an add to put that person into the remote servers list of
users.
The final thing to check is the amount of RAM on the UNIX machine.
SCO UNIX requires a minimum of 8 meg of RAM. It also requires an
additional .5 Meg of RAM for each user.
GRUBTI01 - 03/10/94
Reference:
7/15/98 3:24:41 PM
Last Modified: 01-SEP-99