W&P wrote:
Hi New York

You must be finding me incredibly hard work.

Are you saying I need to install nopcommerce on the hosting server?

or re-install it on my computer choosing the SQL option instead of compact?

Isn't there any way to change it in settings?


Yes, do it on the host server.  This is just a test to see if it Compact will work there.
(If you re-install on your PC with SQL Server option, you would need a SQL Server to point to.)