Hi Nina,
Question - DSN or DSN-LESS. Easiest method to answer - are you paying for hosting. If so - you need to upload the database where they want (sometimes a folder called data), Brinkster uses the folder DB. And notify your host you need "(databasename)" mounted.
If it is DSN, the below applies. For DSN-Less there is just a slight change. But the below will work up to when you upload it.
first you need to connect to the database. UD4 uses a connection file.
Which to back up - first you have to have the database,
Second - make a ODBC connection on your computer (control panel - odbc - Add).
Third - back in UD4 - on define sites screen. Application server. Select asp on server model - then plug in all of your information.
Fourth - on a page in UD4 - select Modify - then Connections, then you probably need to select NEW. Select Data Source Name, new box pops up - click Local DSN. Type in the name you want - on Define - type name of database - select the database. Click on out of there and your connection is made.
Try that, hollar when you run into a difficulty - it seems complex at first - but do one or two and you'll be doing it one handed

"If you feel a post has been helpful to you, click on the link at the bottom of their post to cast a vote for "TipMaster Of The Week". You don't need to be the one who asked the question to vote"
Stuart