While configuring DSN using Oracle ODBC driver, one might encounter error "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed". Cause being, Permissions of the remote desktop software did not allow the user access via the remote desktop software.
Do the following to resolve the issue:
1. Select Administration Tools , Local Security Setting and Local Policy.
2. Then select "User Rights Assignment"
3. Double click on "Create Global Objects"
4. Select Add User or Group.
5. Make sure Object Types Group Box is checked.
6. Select Locations and highlight the name of the server you are working on (Not the Domain).
7. Enter "Remote Desktop Users" or "Everyone" (without the quotes) into the Object Names Box.
8. Select OK.
9. Add the same users to the group "Power User".
10. If this does not work, after step 8 a reboot may be required.
Subscribe to:
Post Comments (Atom)
18 comments:
Thanks .... It's working for Citrix Also
Your solution actually worth a million thanks. We had the same problem but we were connecting via Citrix Server n made de suggested changes and it worked!!!!!!
Thanks a lot
Owwwww Work very well !!! I add the 3 groups as you said. YOU resolve A BIG problem which was here since few years !
YOU'RE THE ONE !
Thanks so much for this solution.. It fixed my problem. Looks like you posted this a few years back, but users are still facing this issue and this worked like a charm!
Thanks, it works
Wonderful, the problem suddenly appeared after adding the Oracle10g client on a workstation that had used and needs to continue using Oracle 9i client also. Thanks.
it's nice solution but not worked in our scenario please sugest another one anybody help me
Great! It solevd my problems! thanks a lot!
trillions of thanks....its working
YOU'RE HTE MAN!!! this Little trick have sabe our asses from a real kick!
GREAT JOB!
too good..thanks \m/
Thanks Bro, It's working.
Respect!
I have a problem in oracle client I installed opera vision in our computer when I opened excel and logon on to vision.
Excel gave me a following error (Oracle ODBC : Driver's SQLAllocHandle on SQL_HANDLE_ENV failed) i changed permission on every folder like oracle vision
I changed permission on following user Authenticated user. But it’s still same error please help me am thankful to you.
I installed on administrator user its working fine when I installed on domain user clien PC it’s not working please give me any suggestion.
`````
Thanks Man... That's working fine for me.. Tons of thanks to you..
You posted this solution on 2007, Its 2016, still we are making use of your post!! It worked simply awesome.. Thanks a ton for your solution Man!!!
Thank a lot. This post help me solve the problem ! even though it's nearly 10 years old now.
Thank a lot!!!!
Thank you again Sir. This fix worked again her in Mar 2018
Post a Comment