IM004 Microsoft ODBC Driver Manager Error

[Former Member]

Does anyone know how to correct this error?

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Thanks

Kevin

[Former Member]

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

http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/drivers-sqlallochandle-on-sql_ha...

Rohit

[Former Member]

I get this error when trying to refresh a report that accesses an oracle 10g database.

Kevin

[Former Member]

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