Re: help connecting to oracle via javascript with osauthent

Wyatt wrote:
> 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.

There is an init.ora parameter called OS_AUTHENT_PREFIX. It defaults to OPS$. So you would have to have a user named OPS$SYSTEM if it is the default.

jg

--
@home.com is bogus.
http://online.wsj.com/public/article/SB115457177198425388.html?mod=technorati
propaganda 101