Connect Sqlstate Im004 Microsoft
Posted : adminOn 3/25/2018
Senior Member I installed 10.2 client on Windows 2000 Terminal Server. Siemens Tia V13. 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 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed' I have reviewed the numerous other posts regarding this error and I've executed the following recommendations: My oracle_home 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?
Senior Member I installed 10.2 client on Windows 2000 Terminal Server. I created the system dsn odbc connection. Execute Jar File Using Ant on this page. 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 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed' I have reviewed the numerous other posts regarding this error and I've executed the following recommendations: My oracle_home 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.
Unable to connect sqlstate im004 driver's sqlallochandle on sql_handle_env failed. 'unable to connect sqlstate im004 [microsoft] [ODBC driver manager]. Jul 19, 2005 Oracle ODBC connection problem. Oracle Database Forums on. Unable to connect SQLState=IM004 [Microsoft]. This version of the Microsoft driver has the location.
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?