Ok, I am trying to modify a login page to use the username and password to run a stored procedure which returns the username and password for this specific application.
username + pass > sproc > appusername + apppass
So basically users don't have to remember multiple logins and can use one universal. I have this working, unfortunately, it is a 3 page process that requires multiple clicks.
The first page they enter their known user+pass, click submit
that passes the variables to a page that runs the sproc and returns the application specific user+pass and places them in HIDDEN textboxes. When they click submit again, it passes those to the actual login page where they must click submit yet again to enter the application.
Is there a better way of doing this? I was able to make this all one page/process with ASP.NET but the application I am passing to is Classic ASP and they don't play nice togather with variables.
Ideally, I'd like them to be able to enter their known username and password, click submit, which runs the sproc, returns the alternate credentials, and automatically POSTs those to the final page.
Please forgive my complete ignorance of old school VB