Asp and Oracle

[ThunderMusic]

Hi,
I'm trying to connect to Oracle from my asp page and the connection
fails. I use this sub to connect. If I want to connect to an Access db, it
works fine with the good connection string, but if I want to connect to
Oracle, it does not work (yes, I changed the connection string). Can someone
point me what is wrong in it please?

thanks

(here is the sub)
public sub CreateConnWithOracleDB(byval strUser, byval strPass, byval
strConnection, byref Conn)

' Create an ADO Connection to connect to the database.
Set Conn = Server.CreateObject("ADODB.Connection")

Conn.ConnectionTimeout = 15
Conn.CommandTimeout = 30

' This line is for the Oracle database:
Conn.Open "Provider=OraOLEDB.Oracle;Data Source=" & strConnection &
";User Id=" & strUser & ";Password=" & strPass & ""
end sub

ThunderMusic

[Ray at]

"ThunderMusic" <NOdlatulippe@teldig.comSPAM> wrote in message
news:OGi6qxZYDHA.2344@TK2MSFTNGP09.phx.gbl...

> Hi,
> I'm trying to connect to Oracle from my asp page and the connection
> fails.

How? Do you get an error?

Ray at work

[ThunderMusic]

yes, the page does not load and the error is precisely on the Conn.Open
line. the error is this

"Error Type:
OraOLEDB (0x80004005)
ORA-12640: Authentication adapter initialization failed
/dvd/scripts/db.asp, line 53"

And the provider is installed on the machine because I connect with the same
database from my visual basic application using data environment. So it's
something else.

can you see what it is?

thanks

ThunderMusic


"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:%23yCy80ZYDHA.2648@TK2MSFTNGP09.phx.gbl...

>
> "ThunderMusic" <NOdlatulippe@teldig.comSPAM> wrote in message
> news:OGi6qxZYDHA.2344@TK2MSFTNGP09.phx.gbl...

> > Hi,
> > I'm trying to connect to Oracle from my asp page and the connection
> > fails.

>
> How? Do you get an error?
>
> Ray at work
>
>

[ThunderMusic]

ok, I found it, I changed my sqlnet.ora. for the variable
"SQLNET.AUTHENTICATION_SERVICES" I changed (NTS) to (NONE) and it worked
just fine. It's the solution advised on the Oracle site.

thanks

ThunderMusic

"ThunderMusic" <NOdlatulippe@teldig.comSPAM> wrote in message
news:%23Udvk6ZYDHA.1916@TK2MSFTNGP12.phx.gbl...

> yes, the page does not load and the error is precisely on the Conn.Open
> line. the error is this
>
> "Error Type:
> OraOLEDB (0x80004005)
> ORA-12640: Authentication adapter initialization failed
> /dvd/scripts/db.asp, line 53"
>
> And the provider is installed on the machine because I connect with the

same

> database from my visual basic application using data environment. So it's
> something else.
>
> can you see what it is?
>
> thanks
>
> ThunderMusic
>
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:%23yCy80ZYDHA.2648@TK2MSFTNGP09.phx.gbl...

> >
> > "ThunderMusic" <NOdlatulippe@teldig.comSPAM> wrote in message
> > news:OGi6qxZYDHA.2344@TK2MSFTNGP09.phx.gbl...

> > > Hi,
> > > I'm trying to connect to Oracle from my asp page and the

connection

> > > fails.

> >
> > How? Do you get an error?
> >
> > Ray at work
> >
> >

>
>

[TurkBear]

In General for web-based Oracle access, the database cannot use NT authentication methods since no authentiicated user
name is passed to it by the web server - as you found, setting it to NONE ( or just removing that line from the
sqlnet.ora file ) will solve most of that type of problem..



On Wed, 13 Aug 2003 09:35:12 -0400, "ThunderMusic" <NOdlatulippe@teldig.comSPAM> wrote:

>ok, I found it, I changed my sqlnet.ora. for the variable
>"SQLNET.AUTHENTICATION_SERVICES" I changed (NTS) to (NONE) and it worked
>just fine. It's the solution advised on the Oracle site.
>
>thanks
>
>ThunderMusic
>
>"ThunderMusic" <NOdlatulippe@teldig.comSPAM> wrote in message
>news:%23Udvk6ZYDHA.1916@TK2MSFTNGP12.phx.gbl...

>> yes, the page does not load and the error is precisely on the Conn.Open
>> line. the error is this
>>
>> "Error Type:
>> OraOLEDB (0x80004005)
>> ORA-12640: Authentication adapter initialization failed
>> /dvd/scripts/db.asp, line 53"
>>
>> And the provider is installed on the machine because I connect with the

>same

>> database from my visual basic application using data environment. So it's
>> something else.
>>
>> can you see what it is?
>>
>> thanks
>>
>> ThunderMusic
>>
>>
>> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
>> news:%23yCy80ZYDHA.2648@TK2MSFTNGP09.phx.gbl...

>> >
>> > "ThunderMusic" <NOdlatulippe@teldig.comSPAM> wrote in message
>> > news:OGi6qxZYDHA.2344@TK2MSFTNGP09.phx.gbl...
>> > > Hi,
>> > > I'm trying to connect to Oracle from my asp page and the

>connection

>> > > fails.
>> >
>> > How? Do you get an error?
>> >
>> > Ray at work
>> >
>> >

>>
>>

>