ASP Connect to Oracle using OS authentication

From: Henrik Woldby <xxxwoldby_at_xxxpost5.tele.dk>
Date: Tue, 17 Jun 2003 01:09:55 +0200
Message-ID: <3eee5008$0$97181$edfadb0f@dread12.news.tele.dk>

Hi,

I am trying to connect to my Oracle DB from an ASP page, and I want to use OS authentication, but cannot get it to work :(

There is defined an oracle-user "ops$administrator" with connect privillege The Oracle ini-file contains the parameter : "os_authent_prefix = OPS$" The NT-user currently logged in is "administrator"

I can login from a commandline with the command "sqlplus /@orcl"

My ASP connect string is :

<%
...
set MyCon=server.createobject("ADODB.connection") MyCon.Open "Provider=OraOLEDB.Oracle;Data Source=ORCL;OSAuthent=1" ...
%>

I have also tried with the following connectstrings (without success) :

MyCon.Open "Provider=OraOLEDB.Oracle;Data Source=ORCL;User Id=/;Password="
MyCon.Open "Provider=OraOLEDB.Oracle;Data Source=ORCL;User Id=/;Password=;"
MyCon.Open "Provider=MSDAORA;Data Source=ORCL;OSAuthent=1"

My environment is Win NT (servicepack 4), Oracle 8.1.6

Any suggestions will be appreciated

Best regards, Henrik Received on Mon Jun 16 2003 - 18:09:55 CDT