ERROR [IM004] [Microsoft][ODBC Driver Manager] Fehler beim SQLAllocHandle-Aufruf fÃ¼r Treiber auf SQL_HANDLE_ENV
Yeah … this damm error took me hours of hard work. I was setting up a new version of the IBM DB/2 Database. Finally I was allowed to update from Version 6.1 to the Express 8.1. So I did! After installation my asp.net application was not longer running. It stopped with the error above or was running forever. (To reproduce the error page I had to kill the aspnet_wp task every time)
Sure I tried Google & Co, but it was very hard to find the solution since nearly all error relatet to this where mention Oracle. But finally somewhere was a post which gave me a hint. „Check your PATH!“ So I did. But there was nothing wrong with – I thought. So I tried just for fun to set the DB2 stuff directly after the normal windows stuff. Rebooted and volia! It works!
Once again this is a thing you may don’t want known why it has to be this way… Don’t ask and you wan’t get an answer.
[UPDATE]: I really go to hate this kind of stuff. Once again I got this error. Before I may need to mention that I’ve installed three DBMS. Oracle, Sql Server Express and DB/2. I had the problem with the DB/2 ODBC driver. I need to move the path between the MS-SQL and Oracle. So feel free to try many, many, many ….. diffrent positions. Or – may the best solution ever – install every DBMS in a virtual PC.