yes, you will have to upload from both Dreamweaver Sites.
For the existing site, set the Host directory on the Remote Info tab of the site definition to:
public_html/
For the power store site, set it to:
public_html/store/
this will put the site back together when it is uploaded to the server.
The error message you are getting is saying that there is not a localhost connection created to connect to the power store database. Once you have the power store files in place and edit the Connections/localhost.php file to connect to the powerstore database, you will fix that error.
Thanks Jason, I am going to give this a try tonight and cross my fingers. In spite of the problems I am having (which I know most are due to my lack of knowledge) these programs look like exactly what I needed and wanted. I am just trying to wrap my head around a LOT of new concepts.