Home » Infrastructure » Windows » Unable to connect SQLState=IM004
Unable to connect SQLState=IM004 [message #213451] Wed, 10 January 2007 16:32 Go to next message
TLegend33
Messages: 203
Registered: March 2005
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 [[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?
Thanks.

[Updated on: Wed, 10 January 2007 16:38]

Report message to a moderator

Re: Unable to connect SQLState=IM004 [message #213452 is a reply to message #213451] Wed, 10 January 2007 16:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This issue seems to be addressed in Metalink Note:361325.1.
Re: Unable to connect SQLState=IM004 [message #213632 is a reply to message #213452] Thu, 11 January 2007 10:20 Go to previous messageGo to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
Wow, that could not have been easier or more obvious. Thanks for your help.
Re: Unable to connect SQLState=IM004 [message #233292 is a reply to message #213451] Wed, 25 April 2007 09:47 Go to previous messageGo to next message
UDaniel
Messages: 1
Registered: April 2007
Junior Member
You must set the Security policy "Create global Objects" for the user group, that uses Oracle 10 "
icon14.gif  Re: Unable to connect SQLState=IM004 [message #484830 is a reply to message #213451] Thu, 02 December 2010 23:51 Go to previous message
asnanisatish
Messages: 2
Registered: October 2010
Location: BHOPAL,MP, India
Junior Member
Just a summary of all the discussions
Assume Oracle Client in c:\OraClient folder and web folder as c:\inetpub\wwwroot

1. c:\inetpub\wwwroot must have Read and Execute privlege for IUSR user.

2. c:\OraClient must have Read and Execute privlege for IUSR user.

3. The environment PATH variable must have C:\OraClient\bin included.

4. Don't forget to restart Web Server
Previous Topic: OO4O with javascript
Next Topic: Solution required
Goto Forum:
  


Current Time: Thu Mar 28 04:56:23 CDT 2024