If you have installed Orcas March 2007 CTP and trying to play with SQL Server 2005 Express database using the IDE feature. You might meet with an error mentioning “Unable to find the requested .Net Framework Data Provider. It may not be installed.” while trying the below mentioned steps
In Server Explorer, Add New Connection - > Choose SQL Server 2 - > Provide the local database server information -> (drop down will not be refreshed or if you forcefully type the database name in the text box) and hit OK button. The above mentioned error will block you to go ahead.
I did install Orcas in fresh machine and then installed VS 2005 there. I think that was the issue. But the workaround is little tricky here,
Steps to follow:
Go to the folder C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG
Select the Machine.config and then find the tag <DbProviderFactories> under <system.data>.Then next step is to hide all the provider entries which has either Version=18.104.22.168 or Version=22.214.171.124.
Following are the entries in my machine
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=188.8.131.52, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=184.108.40.206, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=220.127.116.11, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<!--<add name="SQL Server Compact Edition Data Provider" invariant="System.Data.SqlServerCe" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<add name="SQL Server Compact Edition Client Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition Client" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />-->
Then you are ready to work. Everything else will work fine.
Thanks to the entry from where I got the clue to the solution. You could find the bug entry at connect.
thanks ..your solution do work..as i have install orcas and 2005 in same machine, the sql server management do hit unknown error
Thanks for the feedback
こんにちは、クリクリドーナツウォッチャーのこだかです。 クリクリドーナツの行列は、最近少なくなって来たように思えます。 （相変わらず30分以上待ちの時が殆どですけど・・・） ただ、並んでいるときに貰える、揚げたてドーナツがおいしそうなんです。
thanks for that solution, worked fine for me too!
it doesnt work! i still got the same error, everything u said has nothing to do with my problem! i just waste my time for you!
Thanks for solution!
but why we see 3.5 framework providers in 2.0 config?
This was error with March CTP. Now there is no issue with Beta 1.
You are a star. Thank you very much
I got this error when I tried to uninstall Microsoft Sedna beta.
After applying your solution everything works fine
The same error is occuring in visual studio 2008 the live version email me at email@example.com and I will send you the screen shot so you can fix your application !
Here are the steps to recreate the problem and the fix.
On a clean xp box with sp2
- install sql server 2005
- test sql server 2005 and everything will work
- install visual studio 2008 with .BLOAT 3.5 framework
- start vs 2008 go to server explorer try to connect to the local sql 2005 it will throw an error ... but the test connection will work
- if you implement your fix (stated above) VS 2008 server explorer will work but then if you start sql server 2005 that will throw a sqlclient namespace exception connecting to the local sql server during login at least it did on my pc.
- To fix this MICROSOFT PROBLEM back up the machine.config that VS ate and find the file machine.config.default and copy it over as machine.config.
Of course sql server ce will no longer work since that is not in the machine.config.default file but at least sql server 2005 and vs 2008 will both work as far as sever explorer is concerned and the couple of .BLOAT websites I have seemed ok, I didn't test all of them... Tomorrow I will need to ensure this isn't going to adversely effect something else but everything seems as stable as a M$FT product can be... There is an oxymoron microsoft product and stable in the same sentence. Kind of like windows and internet security :) ....
Hopes this saves someone the time it took me to get it working.
Best Regards To All
Hi I am using vs 2008 i am getting the same error i triedeverything ststed above but result is same please help i m in deep trouble.
please mail me....
I have just installed visual studio 2008 and I tried above things still cant get solution...please please help.
i am using vs 2008 (v3.5) i'am getting same error ,i tried everything as shown above but still showing the error. plz help me regarding that
please mail me
thanks in advance
Thanks..buddy..for sharing on the blog..It worked for me.