I am getting following error
SQLAllocHandle: Failed to allocate environment handle 'ENV'.
when reading from db2 table
my query looks
SELECT column list....
FROM #Environmnet variable#Table A E, #Environmnet variable#Table B I
WHERE condition;
SQLAllocHandle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Failed to allocate environment handle is typically indicative of one of two things - that the server does not have enough memory to undertake setting up an ODBC environment, or that the ODBC driver manager could not be found. These, therefore, should be the first areas that you investigate.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.