One of the powerful things about WSS / MOSS is editing list in datasheet view. It’s like working with a spreadsheet except it’s on the site. I recently got a new laptop and couldn’t do this. The error listed below came up.
“The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.
My laptop has IE 7.0, Windows XP, Office 2003 professional, OneNote 2007, Visio 2007. I hadn’t tested this functionality before installing the 2007 products. After I ran a repair on Office 2003, this resolved my issue. Hope this helps others.
PS: Many posts mention upgrading to 2007 resolves the issue. From what I can determine, the COM entries to this feature gets updated when installing 2007 based products while mixing with Office 2003.
I’ll be in Redmond 3/1 to 3/4 staying at the Westin. If you are going to the MVP summit, see you there.
Contact me @ steve AT iislogs.com
or those addicted to twitter steveschofield is my ‘handle’.
I ran into an issue when working on a MOSS farm with the December update for MOSS. Before applying the update, I was running a basic x64 install with SP1. The farm with MOSS had a one-way trust to a user-based domain. The user-based domain didn’t trust the resource domain where MOSS was installed. I needed to use the syntax of stsadm -o setproperty -pn peoplepicker-searchadforsts -pv “domain:example.com,Username,Password” as the article mentioned below since I had a one-way trust.
This article also helped with the syntax.
I strongly suggest you test this in a sandbox environment before applying or attempting to do your production environment.
Hope this helps.
I was trying to reproduce an issue posted on the forums @ (http://forums.iis.net). As with many posts, I mention use Process Monitor. Here is a perfect example.
Find out what PID (process ID) in task manager
Open Process Monitor and isolate the PID (This helps cutdown on noise)
Reproduce the issue. (In my case, notice the highlighted line, it’s looking for c:domainsftprootssuser1). I have the FTP 7.0 service running on a domain controller. It means I need to create the SS (NetBIOS name) as a virtual directory for user isolation. I don’t recommend running FTP on a domain controller, so this is for demo purposes. PS: Once I added the SS virtual directory, I was able to use FTP user isolation.
Here is an article how to setup FTP 7.0
I thank Mark for creating Process Monitor!
Microsoft MVP – IIS
I’m coming up to speed on MOSS and Bob Fox has a straight-forward 20 minute video on backup and restore for MOSS. He shows how use stsadm and the UI. It was a good overview for those coming up to speed on MOSS.
Here is another link with great information on Technet.
I needed to update the ‘Default’ Alternate Address Mapping
stsadm -o addzoneurl -url http://www.example.com -urlzone default -zonemappedurl http://www.example-new.com
Hope this helps someone.
Since I pretty much do a lot with stsadm. It’s work adding the 12 hive to the %PATH%
@set PATH=%PATH%;C:Program FilesCommon FilesMicrosoft Sharedweb server extensions12BIN