I am using VWD 2005 Express on my local machine, and upload my site to my ISP which offers SQL Server 2000. They have a function which automatically creates the database schema for membership roles etc. However, this seems a waste as I am not sure how I can get VWD to interact with this database on the remote server? Is it possible at all? How do I interact with the database??

Mick

Hi Mick,

You probably can't as it's likely your ISP blocked access to SQL Server over the Internet.

A common practice is to develop locally, and then upload to your ISP. So, you should develop a local database using SQL Server (Express or other editions) and a local test site (using the built-in dev web server).

Once you're done, you upload your files, including the database to your ISP. You probably need to script your database so your host can run that script to recreate your table structure...

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.