<div>
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.<br />
<br />
JY
</div>


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

<div>
<div class="content wysiwyg-content">
Hi Experts. <br />
<br />
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. <br />
<br />
The settings I choose in the Add Connection wizard result in &quot;Data Source=.\SQL2005WEB;Attach<wbr />DbFilename<wbr />=&quot;C:\Progr<wbr />am Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<wbr />MyDatabase<wbr />.mdf&quot;;Pers<wbr />ist Security Info=True;User ID=sa;Connect Timeout=30;User Instance=False&quot;. <br />
<br />
With these settings I can get &quot;Test connection succeeded&quot; but the OK button errors with &quot;The ability to open this connection is not supported in this edition of Visual Studio&quot;<br />
<br />
I have vb express 2008 and SQL Server 2005 Enterprise edition installed (with one instance named SQL2005WEB)<br />
<br />
Hope you can help.<br />
Thanks in advance,<br />
<br />
JY
</div>
</div>


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

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

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.