SPRadGrid Not Showing All SQL Servers

4 posts, 0 answers
  1. Scott
    Scott avatar
    7 posts
    Member since:
    Nov 2010

    Posted 22 Dec 2010 Link to this post

    I have got SPRadGrid to work on SP Lists but when I open up the Designer and click data binding I only see about half of my SQL servers to choose from. The account I am using should have read access to more; is there a way to force a data binding through the web part? Thanks.
  2. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 23 Dec 2010 Link to this post

    Hello Scott,

    SPRadGrid has been designed to use the ADO.NET mechanism for listing Sql Server instances so that our customers not be required to install additional components on their client machines. Unfortunately, MS admit that the listing of the SqlServer instances may not be complete and may vary on two consecutive calls. You can find more information on that in the following msdn article:
    http://msdn.microsoft.com/en-us/library/a6t1z9x2.aspx

    Furthermore, do make sure that the machines which sql server instances are not listed have the Sql Browser Services started and if their behind a FireWall the Sql Browser Service port/ports should be exposed.

    Regards,
    Tsvetoslav
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

  3. ronald
    ronald avatar
    1 posts
    Member since:
    Feb 2011

    Posted 21 Feb 2011 Link to this post

    Hey,

    i have the same problem (in my RadControlsSP) WebPart, firewall ports are open, sql Browser is running, the problem is the current network. My sql Server is not in the local network. In MSDN SqlDataSourceEnumerator to locate data sources on a network.

    can i hardcoded the connection string or list instances from other network ?

    Please help me
  4. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 21 Feb 2011 Link to this post

    Hi Scott,

    Unfortunately, it is still not possible to hardcode the Sql connection string - however, our development team will do its best to add it among the other improvements for the SharePoint web-parts for the Q1 2011 official release which is about  a month away.

    Greetings,
    Tsvetoslav
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
Back to Top