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,