Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!i3g2000cwc.googlegroups.com!not-for-mail
From: "Wyatt" <wyattwright@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: help connecting to oracle via javascript with osauthent
Date: 8 Aug 2006 08:26:48 -0700
Organization: http://groups.google.com
Lines: 35
Message-ID: <1155050808.883951.139630@i3g2000cwc.googlegroups.com>
NNTP-Posting-Host: 63.126.167.98
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155050813 22164 127.0.0.1 (8 Aug 2006 15:26:53 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 15:26:53 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i3g2000cwc.googlegroups.com; posting-host=63.126.167.98;
   posting-account=iSVeWAwAAACdL6kpoEb2DbPE2aRyPQTf
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272367

I'm trying to connect to an oracle 10g database with javascript using
os authentication.  For now, I'm running the script on the database
host.

Using sql*plus, I can connect with "connect / as sysdba"

this script works
var connectionString = 	"Provider=OraOLEDB.Oracle;"
			+ "Data Source=orcl;"
			+ "OSAuthent=0;"
			+ "DBA Privilege=SYSDBA;"
			+ "User Id=system;"
			+ "Password=***;";

var cn = WScript.CreateObject("ADODB.Connection");
cn.Open(connectionString);
cn.Close();

This script does not work, with error:
ORA-01017:invalid username/password; logon denied
var connectionString = 	"Provider=OraOLEDB.Oracle;"
			+ "Data Source=orcl;"
			+ "OSAuthent=1;";

var cn = WScript.CreateObject("ADODB.Connection");
cn.Open(connectionString);
cn.Close();

I've tried variations ofthe connectionstring, but get the same error
message.
Am I missing and argument in the connectionstring?
Is there a different method to use?

Thanks in advance.

