How do I connect to a database using Visual Web Developer Express 2008

I recently installed Visual Web Developer Express 2008 and SQL Server 2008 Express Edition. I created a database on the server, a website on VWD and when attempting to make a database connection from VWD I get the message The file is in use by another program. Any help would be appreciiated.
jbottsAsked:
Who is Participating?
 
pr0t0c0l12Commented:
Go to the Server Explorer window first. Then select Connect to Database. Follow the prompt and you will have a connection.  Once you have the connection and start creating your website, please don't forge to include the web.config file.  as well as all the files in the folder where you created the website.  
Te most important thing is go to your asp.net configuration and make sure that all settings are correct and that you are pointing to the instance in where your SQL server is.  I know that this might be a little bit too much but you need to watch this video to learn how to make a connection to it.  
http://www.asp.net/learn/3.5-videos/video-362.aspx
0
 
Anthony PerkinsCommented:
>> I get the message The file is in use by another program. <<
Perhaps you are attempting to attach the database.  This usually occurs when you have inadvertently left AttachDbFilename="Some database file path goes here"  in your connection string.
0
 
jbottsAuthor Commented:
This was helpful. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.