Orcas March 2007 CTP Error: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Orcas March 2007 CTP Error: Unable to find the requested .Net Framework Data Provider. It may not be installed.

  • Comments 14

 

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=3.5.0.0 or Version=9.0.242.0.

 

Following are the entries in my machine

<DbProviderFactories>

      <add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, 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=2.0.0.0, 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=2.0.0.0, 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=2.0.0.0, 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=3.5.0.0, 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=3.5.0.0, 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=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />-->

 

    </DbProviderFactories>

 

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.

 

Namoskar!!!

Leave a Comment
  • Please add 2 and 7 and type the answer here:
  • Post
  • thanks ..your solution do work..as i have install orcas and 2005 in same machine, the sql server management do hit unknown error

  • Kenneth,

    Thanks for the feedback

  • こんにちは、クリクリドーナツウォッチャーのこだかです。 クリクリドーナツの行列は、最近少なくなって来たように思えます。 (相変わらず30分以上待ちの時が殆どですけど・・・) ただ、並んでいるときに貰える、揚げたてドーナツがおいしそうなんです。

  • Hi,

    thanks for that solution, worked fine for me too!

    Zsolt

  • 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

    Thanks

  • The same error is occuring in visual studio 2008 the live version email me at markgordon_007@yahoo.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

    Mark Gordon

  • 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....

    er.kapil.kapoor@gmail.com

    kapilkapoor_16@yahoo.com

    I have just installed visual studio 2008 and I tried above things still cant get solution...please please help.

  • Hi

    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

    mrudula.bhale@gmail.com

    bhale_mrudul@rediffmail.com

    thanks in advance

    mrudula

  • Thanks..buddy..for sharing on the blog..It worked for me.

Page 1 of 1 (14 items)