Sunday, February 12, 2012

Cant connect to database

I just did a ton of work in SQL Server Management Studio Express and now I want to access the database from a Web Developer 2005 Express Edition application. Can't find any documentation on how to connect to the database from vwd. Any assistance would be appreciated.

Thanks,

Tom

Use the same ConnectionString you used to access the database in MS SQL Server Management Studio Express, just change the Server Name, Database Name, UserID and Password (if exists) to the correct one and Use it for VWD.

Good luck.

|||

I'm sorry. I guess I didn't explain myself well enough. I want to see the database I created in MS SQL Server Management Studio Express in the VWD Solution Explorer. I have tried to 'add and existing item' to try to import the database but it gives me an error: 'The file cannot be opened because it is being used by another process.'

I thought I might be trying to access the database from VWD incorrectly. I'm just looking for the right way to include this database in Solution Explorer.

|||

Never mind. I figured it out. I connected to the database through the View | Database Explorer menu and not the Solution Explorer Add Existing Item. Thanks for your help. I just needed to dig a little deeper.

No comments:

Post a Comment