Related Topics • INFO: Creating a Link to ILLiad in Microsoft Access • INFO: Dates and Date Ranges in ILLiad

Other Support Options • Contact Atlas Systems Phone Numbers, Support Options, Online Help, and more. • Listserv Pose a question to other users.

Page Tools Print this page E-mail this page

Feedback How helpful was this article? 5 Best 4 3 2 1Worst 0 N/A Suggestions:

SYMPTOMS

When attempting to use the ILLiad Web Pages, anytime a user presses any button, they'll receive either a 500 error or a specific error of "BDE cannot be initialized".

ERROR MESSAGES

In order to see the specific error reported in Internet Explorer, you need to make sure that the "Show Friendly HTTP Error Messages" option in IE is turned off. This is under the Tools|Internet Options|Advanced tab.

The error you will receive is:

Exception: EDBEngineError
Message: An error occurred while attempting to initialize the Borland Database Engine (error $2B05)

CAUSE

Permissions have changed on the ILLiad server. In many cases, these permissions could have changed in the past at some point, and just recently went into effect when the server was rebooted. The ILLiad Web DLL remains resident in memory once loaded, so in many cases, a problem won't be seen until a reboot.

RESOLUTION

You need to reset the permissions for the IUSR anonymous user. In the commands below, replace IUSR_ILLIAD with the anonymous user that your IIS web server is set to use. Also, if you have your web pages stored in a location other than c:\inetpub\wwwroot\illiad\*.* then you'll need to change that path as well (or any other paths that are different on your server). These commands will add the anonymous user access back to the necessary paths, leaving all other permissions settings unchanged.

Run the following 4 lines from a command prompt on your server:

cacls "c:\program files\*.*" /E /G IUSR_ILLIAD:R
cacls c:\windows\temp /E /G IUSR_ILLIAD:F
cacls c:\windows\system32\*.* /E /G IUSR_ILLIAD:R
cacls c:\inetpub\wwwroot\illiad\*.* /E /G IUSR_ILLIAD:R

This script gives read permission to the anonymous web user to the directories listed as well as write access to the temporary windows directory. Be sure to check path names and the value for the anonymous user in the script before running it on your server. Also, note that after changing permissions on the server, you should reboot the server to reset the web dll and verify that all changes have successfully applied.

MORE INFORMATION

The CACLS command will let you change permissions for any folders on your server:

CACLS: Displays or modifies access control lists (ACLs) of files

CACLS filename [/T] [/E] [/C] [/G user:perm] [/R user [...>
[/P user:perm [...> [/D user [...>
filename Displays ACLs.
/T Changes ACLs of specified files in
the current directory and all subdirectories.
/E Edit ACL instead of replacing it.
/C Continue on access denied errors.
/G user:perm Grant specified user access rights.
Perm can be: R Read
W Write
C Change (write)
F Full control
/R user Revoke specified user's access rights (only valid with /E).
/P user:perm Replace specified user's access rights.
Perm can be: N None
R Read
W Write
C Change (write)
F Full control
/D user Deny specified user access.
Wildcards can be used to specify more that one file in a command.
You can specify more than one user in a command.

Abbreviations:
CI - Container Inherit.
The ACE will be inherited by directories.
OI - Object Inherit.
The ACE will be inherited by files.
IO - Inherit Only.
The ACE does not apply to the current file/directory.