Problem connecting VB Express 2008 to SQL 2005 Entreprise (not express)

Hi Experts.

I am having problems connecting to a local database. I am trying to connect to a local MDF file stored on my C drive by adding a data source. It is attached to a local instance of SQL Server 2005 Enterprise edition.

The settings I choose in the Add Connection wizard result in "Data Source=.\SQL2005WEB;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MyDatabase.mdf";Persist Security Info=True;User ID=sa;Connect Timeout=30;User Instance=False".

With these settings I can get "Test connection succeeded" but the OK button errors with "The ability to open this connection is not supported in this edition of Visual Studio"

I have vb express 2008 and SQL Server 2005 Enterprise edition installed (with one instance named SQL2005WEB)

Hope you can help.
Thanks in advance,

JY
jeewaiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jeewaiAuthor Commented:
Thanks QPR. I saw the post and wanted to get additional views and / or new development that would allow VB express to connect. I guess that would be it.

JY
0
Tommy11bCommented:
The database file(s) are already attached to your version of Sql Server, no need to Attachdatabase again with your connection string. Take a look at the SqlConnectionStringBuilder class in the helpfile, it has some easy to follow examples.
0
jeewaiAuthor Commented:
Thanks for the advices.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.

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.