Click here to Skip to main content
14,427,818 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hello I have following connection string it keeps giving me error
Unable to find the requested .Net Framework Data Provider. It may not be installed.

this is the connection string

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
          ConnectionString="< Server=xxx.xx.xxx.xxx;Uid=xxxx ;Password=xxxx;Initial Catalog=moment1v_forex >"
          onselecting="SqlDataSource2_Selecting"
          ProviderName="< System.Data.SqlClient />"
          SelectCommand="SELECT * FROM [test]">


Thanks
Posted
Updated 8-Nov-11 17:59pm
v2
Comments
   
Asking just in case:; are you sure the data provider is really installed?
--SA

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

try in the followin way:

<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:ConnString %>" selectcommand="SELECT [PhotoId],[Thumbs_Path] FROM [PHOTO_GALLERY]" xmlns:asp="#unknown"></asp:sqldatasource>



and int he web.config file add the connectionstring as:
<add connectionstring="server=.\SQLEXPRESS;database=XXX;Trusted_connection=True;" name="ConnString" providername="System.Data.SqlClient" />
   
Comments
EricThe 9-Nov-11 16:18pm
   
thanks it worked
member60 10-Nov-11 1:38am
   
You are wel come.Enjoy coding!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100