Hello to everyone in DevX land, first time power alert!
I've just been following the Custom Membership Provider article here on DevX:
I am now trying to alter it to pull the membership data from an Oracle Database. I have changed the connection string in the web.config to:
and have changed the query string in validate user to:
Provider=msdaora;Data Source=Source;Port=1521;User Id=MyUser;Password=MyPass;
but whenever I try to login it gives me the login failed message.
Select * From tresham.tresh_users WHERE " & _
"tu_username=@username AND tu_password=@password
All other code is the same as the tutorial. I am actually using the downloaded files as the one I made while following the tutorial didn't work for some reason!
Has anyone got any clues as to why this might be working? Its something to do with the DB as this is all I have changed, but the connection string above I use for some other .Net pages so I'm sure there is nothing wrong with that.
Thanks in advanced for your help.
I am using VS 2005 with .Net framework 2.0 and Oracle v220.127.116.11