My question is once that I've got the example website working, I want to move it to a server. I used SQL 2005 Express for the development machine but the server is running SQL 2k. How do I convert the connection string so that when I copy the site to the new server it will find the SQL Svr 2k and work? In the past I did things with DSN's and am not sure how to proceed here.

thanks for any help you can give.

You just remove the section User Instance=true from the connection string. Then copy the database .mdf and .ldf files into the data directory of your server (probably something like Program Files\Microsoft SQL Server\80\MSSQL\Data for SQL Server 2000), and attach the database using the SQL Server Enterprise manager utility. You cannot just "copy the site" if the target database server is using SQL Server 2000 - you must attach the database files using Enterprise Manager or the equivalent T-SQL Script.

Thanks. I'll try that.

Chris