First of all, I'm using WSS 3.0.

Actually, I face this error alot, I don't the reason.

When I read this article, I followed the above steps, but the problem is still exists.

I hacked the page's code using SharePoint designer, and I found that the problem is in

"DataSource", that the web part uses, whan I remove it, I have no error, but ofcourse. there is no date.

So, there is a problem in the "DataSource, how can I overcome this problem.

"Highlight the broken data view, and go into split view (half code, half design). From the code portion highlighted, look for the ListName Property"

Well when I get to this step my data views don't have a listname property so it seems this fix won't work :(

However, I did manage to fix it.  Following the same steps as above except instead of looking at "listname" I copied "listid" and replaced it in the old webpart.  Now it works.

Hi, I am struggling in displaying the "showdata" after passing the queryex to the search webservice in sharepoint designer .I am getting the following error

" The server returned a non-specific error when trying to get data from the data source. check the format and content of your query and try again.if the problem persists,contact the server administrator"

i searched many threds,could not find any solution. please respond MVP's and geeks.

i can retrieve the results using the tool

http://www.mosssearch.com/searchwebservice.html

provided by Shankar's musings article

http://techdhaan.wordpress.com/2008/06/03/moss-2007-employee-directory-web-part-using-search-and-data-view-web-parts/

here is my queryEx:

<QueryPacket xmlns="urn:Microsoft.Search.Query"> <Query><SupportedFormats><Format>urn:Microsoft.Search.Response.Document:Document</Format></SupportedFormats><Context> <QueryText type="MSSQLFT" language="en-us">select preferredname,Title, Path, Description, Write, Rank,Size from scope() where "scope" = 'people' order by preferredname ASC</QueryText></Context><Range><StartAt>1</StartAt><Count>100</Count></Range><EnableStemming>true</EnableStemming><TrimDuplicates>true</TrimDuplicates><IgnoreAllNoiseQuery>true</IgnoreAllNoiseQuery><ImplicitAndBehavior>true</ImplicitAndBehavior><IncludeRelevanceResults>true</IncludeRelevanceResults><IncludeSpecialTermResults>true</IncludeSpecialTermResults><IncludeHighConfidenceResults>true</IncludeHighConfidenceResults></Query></QueryPacket>

and i also can see the result query by using this code in visual studio webreference program.. this is the program i used for debugging:

class Program

   {

       static void Main(string[] args)

       {

           sharepointdev.QueryService qs = new ConsoleApplication2.sharepointdev.QueryService();

           qs.PreAuthenticate = false;

           qs.Credentials = System.Net.CredentialCache.DefaultCredentials;

           DataSet ds = new DataSet();

           //string ds;

           ds = qs.QueryEx(@"<QueryPacket xmlns=""urn:Microsoft.Search.Query""> <Query><SupportedFormats><Format>urn:Microsoft.Search.Response.Document:Document</Format></SupportedFormats><Context> <QueryText type=""MSSQLFT"" language=""en-us"">select preferredname,Title, Path, Description, Write, Rank,Size from scope() where ""scope"" = 'people' order by preferredname ASC</QueryText></Context><Range><StartAt>1</StartAt><Count>1000</Count></Range><EnableStemming>true</EnableStemming><TrimDuplicates>true</TrimDuplicates><IgnoreAllNoiseQuery>true</IgnoreAllNoiseQuery><ImplicitAndBehavior>true</ImplicitAndBehavior><IncludeRelevanceResults>true</IncludeRelevanceResults><IncludeSpecialTermResults>true</IncludeSpecialTermResults><IncludeHighConfidenceResults>true</IncludeHighConfidenceResults></Query></QueryPacket>");

       }

   }

I have also checked the query by directly passing it to queryex method in query service.

http://sharepointdev/_vti_bin/search.asmx?op=QueryEx

and I do get the result set.

all i need is to get the result set once i clik on show data in sharepoint designer. have followed this article(http://techdhaan.wordpress.com/2008/06/03/moss-2007-employee-directory-web-part-using-search-and-data-view-web-parts/) and can not see the result after repated trails in every possible way.

seems like problem is with the sharepoint designer. I have even tried with the sharepoint support link:

http://support.microsoft.com/kb/923173

but has no luck

any suggestions or help is much much appreciated....

can somebody please help me. naresh

Naresh - we are seeing the exact same issue here too.  So far I haven't found a solution and it does appear that the dataview webpart is failing for some reason.  

@Mike and @Naresh: have you seen this blog post on ways to get around using CAML queries in a SOAPDataSource? http://blogs.msdn.com/sharepointdesigner/archive/2008/06/20/data-source-issues-and-workarounds.aspx

I've found this issue can also be caused when a view or table column has a space in it.