locked
Sharepoint 2003 Dataview issue RRS feed

  • Question

  • I am running two sharepoint 2003/wss 2.0 portals.  recently a WSS 2.0 patch and a couple of .net 4.0 patches were installed.  Since the patches, all old and new dataviews show up fine in Sharepoint Designer but through the browser it shows "Unable to display"

    Since this happens with new dataviews too, its not a GUID problem.  It looks like the dataviews, when calling to the database, are not passing the creditals correctly - no matter if i use a username/password or windows auth.  the sql servers will report an anonymous access request to the sql server. i  am using kerberos and have my spns all set up.  most of these dataviews have been working for years so i think it has to be the recent patches ... but of course the sharepoint patch KB2494007 cant be uninstalled. 

    any ideas on what to test to debug this would be greatly appreciated.

    Friday, September 16, 2011 2:18 PM

All replies

  • I presume this ("in Sharepoint Designer ") is SPD 2007. Were the Data Views originally created in Front Page 2003 or in SPD 2007 ?
    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Friday, September 16, 2011 2:27 PM
  • the dataviews were created in Sharepoint Designer 2007 for my sharepoint 2003 portals. 
    Friday, September 16, 2011 2:32 PM
  • It was always a bit tricky using SPD 2007 with v2 sites because of course SPD 2007 was designed for v3 sites and had some functions that did not work together with v2 sites.

    I did read that your dataviews have been working for a long time, but one theory could be that the WSS 2.0 fix "corrected" an error that allowed them to work with v2 sites and so now they can't. The only backing information I have for that theory is that they are visible in SPD 2007 and not visible in the browser. That would tend to indicate that SPD 2007 thinks they are OK but WSS 2.0 doesn't. (replace "WSS 2.0" with "SPS 2003" if that is what you have)


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Edited by Mike Walsh FIN Friday, September 16, 2011 2:55 PM last bracket sentence added
    Friday, September 16, 2011 2:54 PM
  • Thats a good point so i just installed Front Page 2003 and tried making new dataviews.  i still have the same issue.  also FP pulls up the current sites and displays the data perfectly.  

    it really seems like once the sites are displayed in the browser, sharepoint is not passing the credentials correctly .... 

    Friday, September 16, 2011 4:42 PM
  • Ok i realized that if i convert any of my standard lists to a XSLT dataview, it breaks ... so what is done on the backend when a list/item becomes an XSLT dataview?
    Friday, September 16, 2011 6:21 PM
  • looks like i am not the only one

    http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/74499e10-35d2-4e25-8e24-66434eb3d17a/

     

    Friday, September 16, 2011 6:58 PM
  • i just heard back from microsoft ... unless someone has an extended service contract for sharepoint 2003 - they are going to push the hotfix release  out on Dec 13th.  

    the other solution was to restore the databases back to before the patch was installed and reinstall sharepoint (and loose all work since the backup or manually copy all changes)  -- this is not an option for me.

    so if ANYONE has an extended service contract for SPS2003 -- please let me know!
    Thursday, September 22, 2011 3:09 PM
  • If they have an extended service contract with Microsoft, it is *their* extended service contract. They will not be allowed to share files they get through it with anyone who doesn't have a service contract.

     

    It was also unclear what you meant by this "unless someone has an extended service contract for sharepoint 2003 - they are going to push the hotfix release out on Dec 13th.  " Did you mean that the hot fix is available earlier for people with contracts ?

     

    Moderator


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Edited by Mike Walsh FIN Thursday, September 22, 2011 4:26 PM by too many
    Thursday, September 22, 2011 4:26 PM
  • I was told that if someone has the extended contract and needed the fix then they would push up the release date of the hotfix.  without that, since sharepoint 2003 is past its life cycle, it is not scheduled as high of a priority.

    Thursday, September 22, 2011 4:49 PM