Oracle and ASP

[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
it on MS SQL i write:

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

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

Thanks
Ralf

[Bullschmidt]

Don't know if this might hopefully help:

Able Consulting - ADO Connection String Samples
[url]http://www.able-consulting.com/ADO_Conn.htm[/url]

Connectionstrings.com
[url]http://www.connectionstrings.com[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Andrew S]

Just curious, but what is the driver that you used there Ralf?

"Ralf Pelzl" 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
> it on MS SQL i write:
>
> db.connectionstring="driver={SQL Server};TRUSTED_CONNECTION=yes"
>
> but the trusted_connection parameter dont work on oracle. what i have to use
> ?
>
> Thanks
> Ralf
>
>
>
>
>