ASP ODBC error to Oracle

ASP ODBC error to Oracle

Post by » Wed, 05 Oct 2005 02:37:54

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")
conn.Open "dsn=ORACLEProd01;uid=ACHO;pwd=xxxxx"

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.

Error Type:
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
conn.Open "dsn=ORACLEProd01;uid=ACHO;pwd=xxxxx"

I suspect that non admin users having problem running ODBC dsn. Do you
know how to give proper right for the ODBC?