| Unable to connect SQLState=IM004 [message #213451] |
Wed, 10 January 2007 16:32  |
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 #484830 is a reply to message #213451] |
Thu, 02 December 2010 23:51  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
