a common reason for having to do this would be e.g. that the web application was buildt on a local machine using PWS, now it has to be uploaded to an ISP but there you need either a DSN less connection or have to change to another DSN.

what you have to do in this case is to change the connection bit in the already existing ASP code.

if you open any page and view it in the HTML window you will find something like the following for every recordset:

Recordset1.ActiveConnection = "dsn=myDSN;";

this is what you have to replace with the new DSN name or with the DSN less connection string.

you don't have to do this bit by bit. Ultradev has a very powerful find and replace tool. via Edit>Replace you can change this string throughout the whole site in one go.

tip:

if you already know where your site will be hosted and your ISP does create a DSN for you you can simply create a DSN with the same name in your ODBC panel. this way you don't have to change anything when uploading.