Friday, October 19, 2007

Oracle ODBC : Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

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.

18 comments:

Anonymous said...

Thanks .... It's working for Citrix Also

Anonymous said...

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

Anonymous said...

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 !

Anonymous said...

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!

Anonymous said...

Thanks, it works

Unknown said...

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.

Anonymous said...

it's nice solution but not worked in our scenario please sugest another one anybody help me

Dayong said...

Great! It solevd my problems! thanks a lot!

surya said...

trillions of thanks....its working

Anonymous said...

YOU'RE HTE MAN!!! this Little trick have sabe our asses from a real kick!
GREAT JOB!

Anonymous said...

too good..thanks \m/

Anonymous said...

Thanks Bro, It's working.
Respect!

Anonymous said...

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.
`````

Pradeep said...

Thanks Man... That's working fine for me.. Tons of thanks to you..

Anonymous said...

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!!!

Unknown said...

Thank a lot. This post help me solve the problem ! even though it's nearly 10 years old now.

Unknown said...

Thank a lot!!!!

Unknown said...

Thank you again Sir. This fix worked again her in Mar 2018