Print Thread
Running on a terminal server -- strange error
#32637 10/17/06 07:37 PM
Joined: Aug 2004
Posts: 34
P
Member
OP Offline
Member
P
Joined: Aug 2004
Posts: 34
HI. We are trying to run QueryReporter from a terminal server (mulitple people sharing the same executable) and cannot seem to get it to work UNLESS the people trying to run it have ADMIN rights. If those attemting to run off the terminal server have ADMIN rights, it works OK. But others get a strange error when they try to connect to the database -- a simple message box that says 'OK' and an enter button (no other details). Is there anyway to get around this w/o giving everyone ADMIN rights?

Re: Running on a terminal server -- strange error
#32638 10/17/06 08:41 PM
Joined: Aug 2004
Posts: 34
P
Member
OP Offline
Member
P
Joined: Aug 2004
Posts: 34
Corretion: It is a small 'blank' message box with an 'OK' button -- no other information given with the error.

Re: Running on a terminal server -- strange error
#32639 10/17/06 08:47 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Perhaps the Oracle Client directory is not accessible to the non-admin users?


Marco Kalter
Allround Automations
Re: Running on a terminal server -- strange error
#32640 10/17/06 09:11 PM
Joined: Aug 2004
Posts: 34
P
Member
OP Offline
Member
P
Joined: Aug 2004
Posts: 34
Authenticated users appear to have read-execute access to that directory. Hmm. Is there anyway to see the actual error message? (the message box is blank)

Re: Running on a terminal server -- strange error
#32641 10/18/06 09:38 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
The message box is displayed by the Oracle Client Interface library (oci.dll), so there is little we can do about it.

Can the same users use other Oracle tools? Can you also check if the <OracleHome>\Bin directory is listed first in the PATH environment variable?


Marco Kalter
Allround Automations
Re: Running on a terminal server -- strange error
#32642 10/18/06 11:11 PM
Joined: Aug 2004
Posts: 34
P
Member
OP Offline
Member
P
Joined: Aug 2004
Posts: 34
It wasn't (first) but when we made it so it didn't help -- same error message.

Re: Running on a terminal server -- strange error
#32643 10/18/06 11:13 PM
Joined: Aug 2004
Posts: 34
P
Member
OP Offline
Member
P
Joined: Aug 2004
Posts: 34
Sorry, forgot to answer question #1. Yes, I can run SQL-PLUS, for instance, as well as access the ORACLE DB through our normal mfg. software.

Re: Running on a terminal server -- strange error
#32644 10/19/06 06:30 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Does the server have Multiple Oracle Homes?


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 14 (0.007s) Memory: 2.5246 MB (Peak: 3.0403 MB) Data Comp: Off Server Time: 2024-05-16 11:26:56 UTC
Valid HTML 5 and Valid CSS