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.
3 Answers, 1 is accepted
0
Tsvetoslav
Telerik team
answered on 23 Dec 2010, 10:18 AM
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.
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
0
Tsvetoslav
Telerik team
answered on 21 Feb 2011, 06:06 PM
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!