on 04-01-2009 3:30 PM
Does anyone know how to correct this error?
Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Thanks
Kevin
Hello Kevin,
would you let us know when the error is coming?
what is the environment that you are using,what is the version of Oracle?have you done any recent changes to the system?
Please tell in detail
But for your refernce I guess this error is due to the environment variable Oracle_Home
Go through the following thread and let me know if this helps
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kevin
One item that can cause this error is not having the ORACLE_HOME bin directory in your Windows OS path.
Open a command prompt and type either PATH or SET to see if the directory is included. Adjust as required
-
Another user also replied to a similar problem:
I also had this same problem with Oracle 10g. I resolved it by placing Oracle_Home Bin directory first before any other Oracle directory path in the Windows Environment variable Path.
Please follow the following steps:
1.Right Click on My Computer and Click Properties.
2.Navigate to Advanced Tab and click Environment variables.
3.Under the System Variables List select the "Path" variable and click the Edit Button.
On my system I changed the Path variable FROM
E:\Oracle10OWB\bin;E:\Oracle10\bin;c:\Program Files\Oracle\bin;%SystemRoot%\system32;%SystemRoot% ;%SystemRoot%\System32\Wbem;C:\Program Files\Intel\DMIX
TO
E:\Oracle10\bin;E:\Oracle10OWB\bin;c:\Program Files\Oracle\bin;%SystemRoot%\system32;%SystemRoot% ;%SystemRoot%\System32\Wbem;C:\Program Files\Intel\DMIX
This worked for me (I have Oracle 10g).
-
Please check the following links:
http://www.orafaq.com/forum/t/24005/0/
and
http://www.orafaq.com/msgboard/windows/messages/2015.htm
I hope this helps
Regards
Chen
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.