Query in connection

[richasaraf]

Hi all,
I have a query in ASP. I'm a beginner in ASP, and i have to solve a problem.
Well it is as below:
While making Connection in ASP to the Oracle Database, there is hardcoding done for schema, password... but i want to know whether does ASP has any such facility in which we can declare soem variable or similar like tht and accept the connection at runtime, so there is no need to change the password / username ... everytime there is a change.

Please help me out...

Thanks !

[ilaiyaraja]

Hi all,
I have a query in ASP. I'm a beginner in ASP, and i have to solve a problem.
Well it is as below:
While making Connection in ASP to the Oracle Database, there is hardcoding done for schema, password... but i want to know whether does ASP has any such facility in which we can declare soem variable or similar like tht and accept the connection at runtime, so there is no need to change the password / username ... everytime there is a change.

Please help me out...

Thanks !

Pls gothrough these sites....

http://www.connectionstrings.com/

http://www.sqlstrings.com/

[bluebell66]

Hello,This is Venkat here from Bombay.I am a developer in VB and to some extent comfortable with ASP.
About your query,you could try defining variables in ASP using DIM statement
Dim Ccn,Crs,Cusername,Cpassword..then open the table containing Username and Password information,use a do..while loop.. and assign the record to the variables..then check if the user input conforms...This should help you with dynamic authentication,irrespective of change of user information.
Let me know if it works..you can email at [e-mail]
Regards
Venkat