Oracle, ASP and Authentication

[Ralf Pelzl]

Hello,
i've wrote an ASP to connect to our Ora9i DB via ADODB:

<--- snip --->
set db=server.createobject("adodb.connection")
db.connectionstring="driver={Microsoft ODBC for
Oracle};ConnectString=mydb;Uid=me;Pwd=MyPwd"
db.open
<--- snip --->

it works... but now i want to use operating system authentication. if i use
the authentication on MS SQL i write:

db.connectionstring="driver={SQL Server};TRUSTED_CONNECTION=yes ....."

but the trusted_connection parameter dont work with the oracle driver. what
i have to use ?

Thanks
Ralf

[Turkbear]

On Fri, 4 Jun 2004 20:15:19 +0200, "Ralf Pelzl" <ralf.pelzl@cablelink.de> wrote:

>Hello,
>i've wrote an ASP to connect to our Ora9i DB via ADODB:
>
><--- snip --->
>set db=server.createobject("adodb.connection")
>db.connectionstring="driver={Microsoft ODBC for
>Oracle};ConnectString=mydb;Uid=me;Pwd=MyPwd"
>db.open
><--- snip --->
>
>it works... but now i want to use operating system authentication. if i use
>the authentication on MS SQL i write:
>
>db.connectionstring="driver={SQL Server};TRUSTED_CONNECTION=yes ....."
>
>but the trusted_connection parameter dont work with the oracle driver. what
>i have to use ?
>
>Thanks
>Ralf
>
>
>
>
>

2 Things..

The way you use OS authentication is very, very different in Oracle...Read the docs about how to set it up ( it needs to
be configured on the database server...) - ask your DBA

For any connection you should use
a DSN-less connection, not ODBC...


hth

[Ralf Pelzl]

Hi,
thanks for answer. The operating system authentication runs on the server
and works already. Every (Oracle) client can connect without a Uid/Pwd. My
question is: What Parameter i have to set to use the operating system
authentication when i try to connect to the DB via ADODB. When i connect to
a MS SQL database i can use the TRUSTED_CONNECTION parameter. What parameter
i use for an Oracle database ?


"Turkbear" <noone@nowhere.com> schrieb im Newsbeitrag
news:fdl1c0tngf1qrc5j3dm4g3udntobn9jcg7@4ax.com...

> On Fri, 4 Jun 2004 20:15:19 +0200, "Ralf Pelzl" <ralf.pelzl@cablelink.de>

wrote:

>

> >Hello,
> >i've wrote an ASP to connect to our Ora9i DB via ADODB:
> >
> ><--- snip --->
> >set db=server.createobject("adodb.connection")
> >db.connectionstring="driver={Microsoft ODBC for
> >Oracle};ConnectString=mydb;Uid=me;Pwd=MyPwd"
> >db.open
> ><--- snip --->
> >
> >it works... but now i want to use operating system authentication. if i

use

> >the authentication on MS SQL i write:
> >
> >db.connectionstring="driver={SQL Server};TRUSTED_CONNECTION=yes ....."
> >
> >but the trusted_connection parameter dont work with the oracle driver.

what

> >i have to use ?
> >
> >Thanks
> >Ralf
> >
> >
> >
> >
> >

>
> 2 Things..
>
> The way you use OS authentication is very, very different in Oracle...Read

the docs about how to set it up ( it needs to

> be configured on the database server...) - ask your DBA
>
> For any connection you should use
> a DSN-less connection, not ODBC...
>
>
> hth
>
>
>
>