Hi,

I have repeatedly done this on hosted databases. As the previous post suggest, run the program on your CLASSIFIELDDB.

You will need to provide "servername" and "login credentials" obtained for your hosted CLASSIFIELDDB. This can really work.

Your web config should then contain something similar to the below:

<connectionStrings>

<add name="classifiedsConnection" connectionString="Data Source=dbserver  ;database=ClassieFieldDB; User Id=username; PWD=password" providerName="System.Data.SqlClient"/>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=dbserver ;database=ClassieFieldDB; User Id=username; PWD=password" providerName="System.Data.SqlClient"/>

</connectionStrings>

Thanks

/Kadji