Connect Sqlstate Im004 Microsoft
Senior Member I installed 10.2 client on Windows 2000 Terminal Server. I created the system dsn odbc connection. When connected to the terminal server via RDP as a domain administrator, the odbc connection functions appropriately. When connected to the terminal server console as a standard user, the odbc connection functions appropriately. When connected to the terminal server via RDP as a standard user, I get the error: 'Unable to connect SQLState=IM004 MicrosoftODBC Driver Manager Driver's SQLAllocHandle on SQLHANDLEENV failed' I have reviewed the numerous other posts regarding this error and I've executed the following recommendations: My oraclehome is defined first in my path environment variable (path - c: oracle client bin;). I select my folder options (there is no security tab, windows 2000) I select sharing, then permissions.
I allow 'Everyone' and 'Authenticated Users' full control, change & read permissions. I reboot the server. None of this works for me. Does anyone have any useful ideas?
Give More Feedback
Unable to connect SQLState=IM004. 'Unable to connect SQLState=IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed'. This document provides troubleshooting information for the situation where you are attempting to connect to a DB2 UDB database within an ODBC application and.