I am using ASP 3.0 on Windows 2000 server to access Oracle 9.2.
I have following ASP script to create an ODBC connection to Oracle
via ODBC on Windows 2000 server.
SET conn = Server.CreateObject ("ADODB.Connection")
I made connection this way, because my web users will not have user
name for the Oracle server.
Anyways, I strongly suspect it's something to do with access right to
some dll files. The ASP page works fine for any users with Admin right
on Windows 2000 server, even one without access right to Oracle.
However, I get following error message for users without Admin right on
server. Because of very strict security measures, we don't give access
right to all folders in server to everyone. Oh, also, ASP script is in
"Integrated Windows Authentication" mode.
Microsoft OLE DB Provider for ODBC Driver (0x80040E4D)
[Oracle][ODBC][Ora]Error while trying to retrieve text for error
/ndd/nddTrans.asp, line 15
Line 15 is
I suspect that non admin users having problem running ODBC dsn. Do you
know how to give proper right for the ODBC?