Running on a terminal server -- strange error

[psneeley]

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?

 

[psneeley]

Corretion: It is a small 'blank' message box with an 'OK' button -- no other information given with the error.

 

[Marco Kalter]

Perhaps the Oracle Client directory is not accessible to the non-admin users?

 

[psneeley]

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)

 

[Marco Kalter]

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 \Bin directory is listed first in the PATH environment variable?

 

[psneeley]

It wasn't (first) but when we made it so it didn't help -- same error message.

 

[psneeley]

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.

 

[Marco Kalter]

Does the server have Multiple Oracle Homes?