Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 617
  • Last Modified:

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.
1 Solution
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.  
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.
jbottsAuthor Commented:
This was helpful. Thanks

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now