
Open ODBC Connection Without Hardcoding Password
Question: In my ASP page, I open an ODBC connection with: Set Conn = Server.CreateObject(“ADODB.Connection”)Conn.CommandTimeout = 600Conn.open “Database_name”,”Username”,”password”. How can I avoid hardcoding the password in the ASP source? Answer: You have a few options. First, you could use a File DSN and include the ID and password inside the