Problem: Integrated Security on IIS 5 with OLEDB for Oracle

From: Mak <maksengchew_at_hotmail.com>
Date: 28 Jan 2002 23:59:49 -0800
Message-ID: <2c1e8290.0201282359.51b4ee29@posting.google.com>

I encountered the above problem.

Setup:

- Oracle db is installed with IIS on the same SERVER.
- The SERVER's OS is W2k and is a member server in Windows 2000 AD
- Integrated Security is configured on IIS virtual dir. 

ASP Code:
<%	Dim oConn
	Set oConn = Server.CreateObject("ADODB.Connection")
	oConn.Open "Provider=ORAOLEDB.Oracle;Data
Source=myServer;OSAuthent=1;"
	oConn.Close
	Set oConn = Nothing

When a user logon to client machine and accesses the ASP page via web browser. The following error occurred

Error message:
OraOleDB (0x80004005)
ORA-01004:default username feature not supported;login denied.

However, there isn't and problem if the user logons to the SERVER to access this page via browser.

Any help gladly appreciated!
Mak Received on Tue Jan 29 2002 - 01:59:49 CST