Merant Error when running on Windows 2003 via Citrix

[pvanhouse]

We have a dBASE Plus application using the Merant 3.7 ODBC Drivers against a Progress 9.1c Syteline database running on a Windows Server 2003/Citrix server. The application works seamlessly when logged into the Citrix Desktop or Published application as an administrator.

However, when a "regular" user tries to run the application the following error ocurrs every time the application tries to access the database for reading (no writing is done in this part of the application):

server error: [merant][odbc progress driver][progress]system error: Open Interface Driver

I have changed permissions on the Progress folder, the Program Files\Merant Folder, Program Files\Common Files\BDE, my application's folder, and regististry trees for Local Machine\Software\PSC, and Borland to allow "everyone" Modify Access (Read for the registry).

I'm pretty sure it's a permissions problem but can't find or think of any other permissions to change.

 

[Casper]

Hi pvanhouse,

I don't have much time right now but KB P9715 states that with syteline it is required to make sure that in the systems DSN the security required box should be checked (tab advanced).

HTh,

Casper

 

[pvanhouse]

The "Require Security" is checked in the System DSN. To my knowledge everything is set up the same on this citrix server (Windows '03') as it was on the old citrix server (Windows '00). So the difference is likely new security settings in the OS that weren't around ... or were handled differently in the older OS.

The application works fine for administrative users.

 

[pvanhouse]

Problem resolved...
Since I could never find an error message in the application log, and searching Progress/Syteline/Data Direct knowledgebases did no good, I decided to search in the database log on the Progress server and found the error:
"Registry error 5: Could not create the *HOU_PROGRESS* key for the Event Viewer. (5175)"

I checked this error on the Progress knowledgebase and found the resolution, Gave the user "amf\Everyone" Full Control over the registry key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\HOU_PROGRESS" on the Citrix Server.