asp.net and oracle 8i connection problem

[saleryan]

hi..
i'm trying to connect to oracle 8.1.7 in asp.net using integrated security
but i'm always getting a ora 01017 invalid username/password. logon denied
message. my web application is running on iis on windows xp professional.

This is my connection string: data Source=bankiby;integrated security=yes"
i set SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE) and added users to be
identified externally and i set the remote_os_authent=TRUE..

I am able to login through the server with no problems but when i try to
login through a client computer to my web application i get the message ora
01017.



Any suggestions?

 

[Paul Clement]

¤ hi..
¤ i'm trying to connect to oracle 8.1.7 in asp.net using integrated security
¤ but i'm always getting a ora 01017 invalid username/password. logon denied
¤ message. my web application is running on iis on windows xp professional.
¤
¤ This is my connection string: data Source=bankiby;integrated security=yes"
¤ i set SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE) and added users to be
¤ identified externally and i set the remote_os_authent=TRUE..
¤
¤ I am able to login through the server with no problems but when i try to
¤ login through a client computer to my web application i get the message ora
¤ 01017.
¤

Is Oracle installed on your web server or on a remote machine?


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[saleryan]

Oracle is installed on my web server. I'm using oracle administration
assistant for windows NT to define external OS users and I set the
impersonate tag in the web.config file to true. I also noticed that if I
change the impersonate tag in web.config file to False and I added the
aspNET user to oracle as an external user then it works fine. But that
doesn't work when I set the impersonate to true and define my own users.

Seems to me something wrong is happening while passing the username or
password from asp.net to oracle. I checked several times that the user
being passed to oracle is the same user that is defined as an external user
in oracle. I used the following code:
Dim user1 As WindowsPrincipal = HttpContext.Current.User
LblWelcome.Text = "Welcome " + user1.Identity.Name()
The user thats printed everytime is the same as the oracle user defined
externally..
I'm using windows xp professional on both my webserver and client do you
think that could be the problem? That maybe I should use windows NT on my
webserver? If anyone has experience using windows integrated security with
oracle 8.1.7. Please help me here.. Microsoft recommends it but I don't see
any help files explaining the exact configurations on oracle and asp.net..

Thanks

 

[saleryan]

I would like to add that it WORKS if I explicitly set
<identity impersonate="true" userName="IISGroup\userName"
password="password" /> in the web.config file. but it doesn' t work if i
just justa set impersonate=true..


Any suggestions!!

 

[saleryan]

I would like to add that it WORKS if I explicitly set
<identity impersonate="true" userName="IISGroup\userName"
password="password" /> in the web.config file. but it doesn' t work if i
just justa set impersonate=true..


Any suggestions!!