Hi,
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 server 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, the ASP pages works fine for any users with Admin right on Windows 2000 server regardless of having access right to Oracle. However, I get following error message for users without Admin right on server.

Error Type:
Microsoft OLE DB Provider for ODBC Driver (0x80040E4D)
[Oracle][ODBC][Ora]Error while trying to retrieve text for error
ORA-12154
/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?

Thanks,
Junho