Highlighted
Absent Member.
Absent Member.
5988 views

General Failure - Running DBASE App from Netware on Windows

Hi all,

Our company database is coded in DBASE 5 and is hosted on Novell Netware 6.5 servers.

Our users have always used MS DOS PC's with the novell client to run the application but recently we have began testing the application running under windows XP CMD prompt after connecting using Novell Client.

For the most part everything works however we are experiancing a problem on XP that doesn't exist when run on the MS DOS PC's.

Basically when the app tries to run the DBASE USE / FILE commands on a file that the user doesn't have access too a general failure (CANCEL, IGNORE, RETRY) is shown. Strangely if the user hits CANCEL / IGNORE the correct result is returned e.g. FILE returns .F.

The above problem doesn't occur on MS DOS!

After testing it seems that the windows PC somehow 'knows' the file is there and tries to access it and then fails - could this be the case?

Other windows commands such as DIR / MOVE etc return "A device attached to the system is not functioning"

Any ideas on any settings we can change to prevent this from happening?

Thanks

Robbie
Labels (1)
0 Likes
76 Replies
Highlighted
Knowledge Partner
Knowledge Partner

Re: General Failure - Running DBASE App from Netware on Windows

Robbiecookie101,
> Any ideas on any settings we can change to prevent this from happening?


Turn off caching and opportunistic locking.

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: General Failure - Running DBASE App from Netware on Wind

Hi Anders

Thanks for your response

I've run the following commands on the netware server

SET NCP FILE COMMIT=ON
SET CLIENT FILE CACHING ENABLED=OFF
SET LEVEL 2 OPLOCKS ENABLED=OFF

and the problem still exists. Is there anything I can do on the windows / Novell Client side of things?

Robbie
0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: General Failure - Running DBASE App from Netware on Windows

Robbiecookie101,
> and the problem still exists. Is there anything I can do on the windows
> / Novell Client side of things?


No, that should do it. Are you using the latest client?

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: General Failure - Running DBASE App from Netware on Wind

Using 4.91 SP5 on XP.
0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: General Failure - Running DBASE App from Netware on Windows

Robbiecookie101,
> Using 4.91 SP5 on XP.


OK. Note that the server-side settings will not take effect until the
client reconnects. Also set the corresponding settings on the client
just to be sure.

Also note that there are some post sp5 patches available:

07 Feb 2012 - Novell Client 4.91 Post-SP5 (IR1) NWFS.SYS 2 x86
17 Nov 2011 - Novell Client 4.91 Post-SP5 (IR1) NOVEAP x86
23 Jun 2011 - Novell Client 4.91 Post-SP5 (IR1) NMAS Client Setup x86
03 Jan 2011 - Novell Client 4.91 Post-SP5 IR1 NICM.SYS x86
08 Oct 2010 - Novell Client 4.91 Post-SP5 (IR1) NWGINA.DLL x86
30 Sep 2010 - Novell Client 4.91 SP5 for Windows (IR1) x86
30 Sep 2010 - Novell Client 4.91 Post-SP5 (IR1) x86
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: General Failure - Running DBASE App from Netware on Wind

Hi Anders,

We applied all the patches and file caching on the client side was off anyway and we still have the same issue. Is there any other setting besides file caching we need to change on the client side?
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: General Failure - Running DBASE App from Netware on Wind

Just to add to this. I have done some more checks and it definitely seems that the system knows there is a file there even though i have no rights to it. If i try to use a file in dbase file in a subdirectory i do not have rights to, i get the general failure error. If i do the same to a file that doesn't exist in the same directory then i get the standard file does not exist error. Is there some way that the client knows that there are files there even though i do not have rights to them and they do not show in a a dir?
0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: General Failure - Running DBASE App from Netware on Windows

Robbiecookie101,
> We applied all the patches and file caching on the client side was off
> anyway and we still have the same issue. Is there any other setting
> besides file caching we need to change on the client side?


I know of none. I have not use dBase in years, but I support other flat
file databases on NW, ie Access and FoxPro. Try asking in the client
newsgroup in case someone there has any ideas.

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms

0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: General Failure - Running DBASE App from Netware on Windows

Robbiecookie101,
> Just to add to this. I have done some more checks and it definitely
> seems that the system knows there is a file there even though i have no
> rights to it. If i try to use a file in dbase file in a subdirectory i
> do not have rights to, i get the general failure error. If i do the same
> to a file that doesn't exist in the same directory then i get the
> standard file does not exist error. Is there some way that the client
> knows that there are files there even though i do not have rights to
> them and they do not show in a a dir?


The reason why you cannot access it is because another client has opened
it and has exclusive access to it. In the old days you had to flag such
files as "shareable" with the flag command, but I have not had to use that
for decades..

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: General Failure - Running DBASE App from Netware on Wind

The file is shareable and the database isn't in use. The problem isn't necessarily down to dbase itself. As mentioned above, it appears that although i do not have Netware rights to the file, the file system itself appears to know that the file is there. Is there some way that the Netware file system makes files browsable but not actually visible? If we put the same files in a directory that i do not have rights to on a Windows file system i do not get this issue.

I have rights to the volume on netware that has the files on, but not the directory. If i do a dir of the directory i cannot see the files and get the message "A device attached to the system is not functioning".
0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: General Failure - Running DBASE App from Netware on Windows

Robbiecookie101,
> I have rights to the volume on netware that has the files on, but not
> the directory. If i do a dir of the directory i cannot see the files and
> get the message "A device attached to the system is not functioning".


Ah. Why is that? Is it intentional? Does it work if you have full rights
to the directory?

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.