Hello,
I want to create a situation such that when the user refreshes a page he goes to a database to fetch some data via a DSN.

The difference is that i want a popup to prompt me for the DSN password before i can get the data, instead of hitting the Database straight away.

Thanks

You'll need to have an additional page that comes up before the page that accesses the data. This page can have form elements on it to enter the password or use a client prompt (like the "prompt" javascript method) to capture the password. Then the page will send the password back to the server and you'll use it in your connection string.

-Peter