VB Express 2010 tells me it can't find the SQL Server Data Provider

[EDN Admin]

Im trying to port an ASP.NET 4.0 data-driven app to a VB Express 2010 Windows Forms desktop app. The ASP.NET 4.0 app uses a SQL Server 2008 Express database and works fine. I can change/add/delete data in the db with the web app, and I can use SQL Server
Management Studio to modify the database, but when I try to establish a connection to the same database with the "Add new connection" wizard in VB Express 2010, it tells me that it cannot find the SQL Server Data Provider !<br/>
<br/>
How can that be ?<br/>
<br/>
The SQL Server provider MUST be installed because otherwise the web app wouldnt work, right ?<br/>
<br/>
What could possibly be the problem...and how can I fix it ?<br/>
<br/>
Also : where does VB 2010 store connection strings ?<br/>
<br/>
I assume the connection strings for a Windows Forms app <br/>
are the same as the connection strings for the currently operating web app.<br/>
<br/>
I could store the string manually...if I knew where they are stored.<br/>
<br/>
The rest of the data wizards should work once<br/>
I already have a configured connection string, right ?<br/>
<br/>
Thanks for your assistance !
<hr class="sig Juan T. Llibre, ASP.NET MVP 1997-2009

View the full article