Datasheet Component
I did a search and I found out that in order to use
the "EDIT in Datasheet" link in sharepoint you have to
have Office 2003 Pro, now is this correct or is there
anyway you can download just the component so you don't
have to run out and spend even more money on Office 2003
Pro. Tag: Good Reference Material For Share point Services Tag: 15288
Display list of subsites on home page
Is there a way to display a list of subsites on the home
page?
I can add a link to the subsites page, but I cannot get
the subsites to actually be listed on the home page.
I have frontpage 2003 and wss 2003 - I can deal with code
if I am pointed in the right direction.
Thanks, Megan Tag: Good Reference Material For Share point Services Tag: 15284
How can I display filtered private List data on a public web page
We have a Sharepoint list that shows various entries that
are updated quite frequently by the team members. We
would like some of these entries to be available on a
public web page (ie: new & updated entries only).
Currently we are exporting the list to Excel, filtering
it and then posting that list but would like it to happen
automatically if possible.
We are using Small Bus Server 2003 Standard and the
default companyweb, etc.
Any help is appreciated as I am new to SBS and this type
of work.
Thanks
Wayne Tag: Good Reference Material For Share point Services Tag: 15278
Cannot Connect to Server at this time.
In attempting to export data from a list to a spreedsheet (Excel 2003) I
continually get the following error message "Cannot connect to server at this
time. Changes to your data cannot be saved."
There is a fix for "Cannot connect ..... Your list cannot be published."
but this does not work in this instance.
Has anyone encountered this problem, or have any ideas that may aid in
resolving this issue? Will appreciate Tag: Good Reference Material For Share point Services Tag: 15270
webpartstorage question
Hi,
The microsoft documentation on WebPartStorage and property persistance is
very vague and imprecise. For example, from v1.4 of MSP&T 2003 SDK,
explanation of the WebPartStorageAttribute gives the remark:
== ms docs for WebPartStorageAttribute
If a WebPartStorage attribute is not specified for a property,
**Storage.PerUser** is used by default. If a WebPartStorage attribute is
specified for a property but the ControlledExport option is not set,
ControlledExport=False is used by default.
== ms docs
Let's ignore the fact that there is no such enumeration as "PerUser". I
assume they mean Storage.Personal. Now moving on, the Storage enum is
explained as:
== ms docs for Storage enum
Personal: The property will be stored on a per user basis.
Shared: The property will be stored with the same value for all users.
Typically only the administrator can set this property.
None: The property will not be stored
== ms docs
When a webpart property is marked as Storage.Personal, it is NOT actually
stored on a per-user basis, _unless_ you have the page view set to
"personal"; the effective storage of a property marked Storage.Personal in
Shared view is that of a Shared property. The WSS group "Reader" does not
have the rights to change the page from "Shared" to "Personal", hence I
cannot have per-user properties in WebParts that are for usage by Reader
members. An example matrix of how webpartstorage/storage and page view modes
apply is as follows:
page view
| shared | personal
property |====================
attribute | effective storage
==============================
personal | shared | personal
shared | shared | shared
none | none | none
(btw, Microsoft, a matrix like above would help clarify the docs. The three
separate pieces of documentation on the attribute, storage enum and wp
properties need to be assessed together and it is not immediately clear how
it all works without contemplation)
Now, to the crux of the question: not having per-user properties for people
belonging to the reader group seems like a sensible idea if you had
thousands of readers and didn't want to overload the database. But I want to
have per-user persisted webpart properties for users in the Reader group. I
have a WebPart that behaves like a doclib that lets people navigate around
virtual folders -- the currentfolderId is stored in a property marked
storage.personal, but when the page is in the default Shared mode, the
current folder hops around like random as various users simulataneous change
the value of the property which has an effective storage of shared.
(Cookies are not workable as I need information about the current folder,
not the last folder: The cookie collection always returns the LAST requests
cookies, not the cookie being set for the current new folder. If you don't
understand that part, ignore it. Just think "no cookie ideas please". It
doesn't work.)
Any ideas?
- Oisin
b.t.w. Mike Walsh, I know I've cross posted to Portal server -- I don't need
lectures -- I need answers. Both groups ARE relevant, regardless of your
ideas: portal server developers are a superset of WSS devs. Stop criticising
ppl's posting and stick to answering the questions please; I'm sure you've
better things to be doing. Thank you. Tag: Good Reference Material For Share point Services Tag: 15269
Backup in WSS
I have a question regarding backups in WSS.
Some background I am looking for a way to backup a
specific document collect, workspace and or subweb for
archival storage. The user would identify the specific
document collection to archived and the archive backup
would run at a specific time by the Admin. This archive
would be different from the nightly server backup.
Can this be done using SQL2000 or is there a 3rd party app
that can do backups at the document level in WSS?
I have just started researching this but any ideas
comments or suggestions would be appreciated.
Thanks Tag: Good Reference Material For Share point Services Tag: 15267
Session Timeouts
I am having problems with the session timing out in Windows SHarepoint
Services on Win 2003. It is set for 30 min, however, it is not timing out
after that period at all unless i physically close the browser. Any
thoughts??
Thanks,
Garrett Felix Tag: Good Reference Material For Share point Services Tag: 15265
Authentification Problems
Hi there!
A customer of us is trying to evaluating Windows
SharePoint Services to be used with their branch offices
around the world.
They have setup a WSS Server in a DMZ and the branches
access it via HTTPS over the Interenet.
In 2 out of 3 branches it works perfectly. In the US, the
performance is very, very slow (they have a sevenhundred-
something DSL link), the authentification popup comes on
almost every page and when they try to open a office
document, word freezes (most probably, because there is a
security/authentification problem, I guess).
Has anyone a guess what could be the problem? Why does it
work in other countries!?
I'm very thankful for your input, have a good day,
bye
Michael Tag: Good Reference Material For Share point Services Tag: 15254
Give Reader Site Group access to participate in discussions?
I don't want the Reader Site Group of my portal site to add or edit items.
That's easy to set up. But I would like to make an exception for the
Discussion -- here they shoud be able to participate.
When I try to change the Site Groups Rights for Readers there is no
distinction between Discussions and other items.
How do I solve this?
--
Christian, Denmark Tag: Good Reference Material For Share point Services Tag: 15252
How to remove "Add new ..." link for Reader Site Group
When my readers view my SharePoint portal site the see the "Add new ..."
links (announcements, events, etc). They think they can add new items but
when they try to submit the changes they get an error.
Is there a way to remove these links for the Reader Site Group?
--
Christian, Denmark Tag: Good Reference Material For Share point Services Tag: 15251
is it possible to publish a document from a wss site to an area in sps!
What i want to do is that some documents that becomes public value
like an end documentation after a project or sthelse bring them
automatically (like if "completed" are selected by a site user)
embedded in wss document library to an area of sps2003.
How can i do this publishing?
Thx Tag: Good Reference Material For Share point Services Tag: 15246
is it possible to publish a document from a wss site to an area in sps!
What i want to do is that some documents that becomes public value
like an end documentation after a project or sthelse bring them
automatically (like if "completed" are selected by a site user)
embedded in wss document library to an area of sps2003.
How can i do this publishing?
Thx Tag: Good Reference Material For Share point Services Tag: 15245
After converting of a wss list view to xslt view some variables are missing!
Is it a bug in wss2.0, while converting a wss list view to XSLT view
some variables are missing?
i converted a discussion list view to a xslt list view. if users want
to reply a discussion point directly through context menu of an item
they get the message:
Invalid Page URL
null?Threading....
Reply is a function item in ows.js using newFormURL of this listing
view.
After searching and debugging in XSLT view this variable does not
exist.
Therefore i searched for following params in source xsl editor of this
view:
ctx.displayFormUrl = "<xsl:value-of select="$URL_DISPLAY"/>";
i added following params before the line above:
ctx.newFormUrl = "<xsl:value-of select="$URL_New"/>";
Saved it and refreshed the page.
reply with context menu works. Tag: Good Reference Material For Share point Services Tag: 15244
Right to view but not download document from doc. library
Hello,
is there possibillity to change user rights to only view but not download
document from document library? We deployed WSS V2 and Sharepoint portal
server 2003. We can use 3rd party program to do this. Thanks for your help.
Procache Tag: Good Reference Material For Share point Services Tag: 15243
open documents in WSS
Hi,
background information:
WSS 2.0 and SPS2003 and SQL2000Sp3a on a Windows2003 Ent Server
following steps i made for opening documents in WSS within different
issues:
1.
After converting a Data List View (document library) in WSS into XSLT
Data View following related function to open documents are without any
parameters:
onclick="DispDocItemEx(this,'','','','')"
therefore open/edit web parts xslt editor and add following entries:
onclick="DispDocItemEx(this,'FALSE','FALSE','TRUE','SharePoint.OpenDocuments.2')"
now it is possible to open it (examp. if you click on word doc,
document will be opened by your client word application)
2.
I added on a WSS Site a task web part with custom columns.
The items within this task will be preselected by another custom list
through web part connection as described in FAQ by Mike.
Functionality is correct and all members of this wss site can work
with it.
As we know that user can attach files to a task item. users can work
with this attachments and save as a same file on wss site.
If they have files like .doc, .xls and other standard ms office files
user can properly open documents in ms office applications through wss
site.
But after users attached files like .vsd (Standard Visio File) users
can open it but they cant save it (get Messages 111 ...already in
use??):
a. they get another open dialog (file download ...open, save, cancel,
more info)
b. as they get if they open a .doc file (youre opening the following
file ...ok, cancel)
for this point i found a microsoft knowledge base article 832815 and
done described workaround. nothing changed!
i viewed the source and found:
<...onclick="DispDocItemEx(this, 'FALSE', 'FALSE', 'FALSE', '')"
href="...>
damn! where is SharePoint.Documents.2 !!
I searched in onet.xml of tasks, ows.js, dispform.aspx nothing found
how to control parameters to DispDocItemEx().
I guess that this code is rendered on server with a opendocument
control by wss.
have someone any ideas related to this?
thx Tag: Good Reference Material For Share point Services Tag: 15242
Pivot Chart Error
Hi,
I've created a pivot chart that pulls out data from SQL
2000, it does work but it bring up a message now and then
when i query it.
The message is
"This website uses a data provider that may be unsafe.If
you trust the website, click OK,otherwise click cancel"
Do you know what is the cause of this problem? Tag: Good Reference Material For Share point Services Tag: 15239
Field containing current month in a list?
Is this possible in some way? I know [Today] is not allowed in
calculated fields but does anyone know of a workaround?
Regards
Thomas Olsson, MCSD Tag: Good Reference Material For Share point Services Tag: 15238
Datasheet view not working
Hello!
I have a big problem. I've changed my computer and I've got installed Office
2003 Small Business edition. I can't seem to view lists in a datasheet mode.
I have Internet Explorer 6 and I've enabled all ActiveX components in
security. I was able to see it before on my old computer so on server is all
working.
Can anyone help me? I Urgently need datasheet view for normal work. Tag: Good Reference Material For Share point Services Tag: 15236
Share Point Services List Views
How can I make the Announcement list default to showing the Title and
Body fields on a webpage?
In Front Page 2003, I choose insert/database/webpart and choose
Announcements, and insert the webpart onto the webpage.
I add announcements, but they only show the Title!
Thanks. Tag: Good Reference Material For Share point Services Tag: 15234
Adding a Form to a Blank Page
All I really want to do is add some html code that people
can join a newsletters.
But it seems like no matter what I try, Sharepoint pages
don't like the form.
No errors. It just does not work.
If I create the page all by itself elsewhere it works
just fine for subscriptions.
I'm just trying to figure out how I can get the form code
on the main page of my teamsite and have it work. It
doesn't seem like you can add form code to pages as
easily as I thought using FrontPage 2003. Tag: Good Reference Material For Share point Services Tag: 15233
Accessing document library version history
I have a version enabled document library in FrontPage
2003 with documents with different versions, but I cannot
find any way of accessing the version history of these
documents. Does anyone know how to do this?
More details if required:
I have Windows Sharepoint Services installed on Windows
Server 2003 (I am not using Sharepoint Portal Server). I
have a web set up on that server. If I open this web with
FrontPage 2003 I can create a new document library in
that web. By right clicking the document library, and
selecting "Properties", I can "Enable versioning of
documents" in the "Settings" tab. I can create new
documents (I have tried both .htm and .doc) in this
document library and I can check these documents in and
out. When I have a document checked out I can see its
version number in the "Summary" tab of the "Properties"
of the file. This version number increments each time I
check the file in and out.
So it seems as though it is keeping version of the file,
but I have no idea how to view the previous versions. I
have managed to find a single webpage on this topic:
http://www.microsoft.com/resources/documentation/wss/2/all
/adminguide/en-us/stsf07.mspx but this page only mentions
Word, Excel and Powerpoint even though it refers to Web
Designer site groups, and in any case what it says does
not seem to be available in FrontPage 2003. Tag: Good Reference Material For Share point Services Tag: 15232
Share point example .fwp
I was wondering if anyone still has the vitaminsite.fwp file
from www.reviewsharepoint.com
If you have the file can you email it to me at
peter_chang@dimension.com.tw
I am doing some evaluation testing on Share point 2003
Thanks Tag: Good Reference Material For Share point Services Tag: 15230
Search in WSS not indexing .aspx pages
I'm working on WSS project in which a church wants a very traditional,
non-sharepoint looking website with sharepoint technology as "plumbing" to
allow one person to handle the site without html coding. There is a lot of
static html content in the .aspx pages in addition to the web parts. When
search is enabled in SQL2000 content in lists and documents is indexed and
searchable, but the static content is ignored. I've researched an answer, but
no luck. Can in anyone point me in the right direction to fix this problem?
thanks. Tag: Good Reference Material For Share point Services Tag: 15229
SPControl.GetContextSite(Context) Error
Hello Group,
I am having a problem with a very basic custom web part. I know this works
but for some reason my current installation is not cooperating....Here is my
code and the error:
protected override void RenderWebPart(HtmlTextWriter output)
{
try
{
// simple default code
output.Write(SPEncode.HtmlEncode(Text));
// this is where the error occurs
SPSite site = SPControl.GetContextSite(Context);
}
catch(Exception ex1)
{
output.Write(ex1.ToString());
}
}
Here is the error:
System.Security.SecurityException: Request for the permission of type
Microsoft.SharePoint.Security.SharePointPermission,
Microsoft.SharePoint.Security, Version=11.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c failed. at
System.Security.CodeAccessSecurityEngine.CheckTokenBasedSetHelper(Boolean
ignoreGrants, TokenBasedSet grants, TokenBasedSet denied, TokenBasedSet
demands) at
Does anyone have any clues what is causing this? Thank you very much Tag: Good Reference Material For Share point Services Tag: 15228
SharePoint Default Web page
I am using SBS 2003 standard and had a intranet site
working through sharepoint services. After some time and
much work I lost the ability to pull up any site.
"You are not authorized to view this page
You might not have permission to view this directory or
page using the credentials you supplied. "
I have uninstalled and reinstalled the sharepoint
services and even updated the patch. I not sure what to
do but have spent many hours on this now. Do appreciate
any advise and knowladge. Tag: Good Reference Material For Share point Services Tag: 15227
Sharepoint 2003 and Win2003 Web Server Edition
I know Windows 2003 does not support SQL server, but can
it run MSDE which ships with Sharepoint 2003 out of the
box????
Thanks in Advance...
Mike Tag: Good Reference Material For Share point Services Tag: 15226
document library
I installed Windows sharepoint services on windows server
2003. I uploaded several office 2003 documents (e.g.
excel, words, etc.) to my sharepoint site to share out the
documents. Everything works great but i have no clue
where sharepoint kept all the ms office documents, as the
original copy didnt get update when user check out, edit
the document and check back in on the sharepoint site.
need help! Thanks Tag: Good Reference Material For Share point Services Tag: 15223
_vti_bin missing and web parts not working correctly
Hi all,
I recently installed WSS on a server. Everything is working except for some
of the web parts give me the old "could not retrieve properties" error and I
can't edit the site in FrontPage. I went through all of the solutions that
were offered on MSDN until I ran into an interesting problem when trying one
of their fixes for virtual server installations.
basically they say you should run:
C:\Program Files\Common Files\Microsoft Shared\web server
extensions\60\BIN>stsadm.exe -o enumwppacks -url myvirtualserverurl
to find out what web parts are installed on a site. When running this I got
the following back:
There are no items matching the criteria specified.
Thinking this was a bit strange I went looking around the virtual server
directory on the server and found that there is no _vti_bin directory on
that server. I was under the impression that there should be one. Anyway,
I am really stuck now about what to do about this situation. I have a hell
of a lot of content on the site now and don't want to loose it but would
really like to fix the web parts that are not working.
Thanks all for your help.
Colin Wheeler Tag: Good Reference Material For Share point Services Tag: 15220
Can't Edit Document
I have a user that is trying to open a document by using the "Edit in
Microsoft Office Word." However, SharePoint would hang when she does this.
It happens to all documents. She does have Office 2003 installed and is in
the correct group, as a Cotributor, Reader. I don't think it's a permission
issue. Has anyone seen this problem before?
Joel Tag: Good Reference Material For Share point Services Tag: 15214
Sharing private calendar information
Hi,
I'm new to SharePoint, and I have a scenario that I'm wondering whether
SharePoint can help us with.
We have a team of 4-5 people working on support of a service. At least one
of these people need to be on call at any given time. At the moment they
communicate with eachother "manually", dividing time on call by email or
phone.
We'd like to publish these users' Outlook calendars to one shared calendar,
enable all users to view eachothers' availability and reserve time slots for
when they're on call.
Two of these users are not members of the same domain/Exchange organization.
Does SharePoint support this out-of-the-box? If not, are there any web parts
available (commercial or freeware) with this functionality?
Ideally we would like two-way sync between Outlook and the shared calendar.
Thanks,
Jørn Tag: Good Reference Material For Share point Services Tag: 15208
User-changed passwords?
Hi,
I'm currently setting up Sharepoint site on a shared
hosted server (hosted by our network service provider).
I am using Sharepoint to create an intranet for 8
people. I have given them permission to access the site
by entering their login and the generic
password, "ChangeMe".
My question is, can the users (I have them at the web
designer level) go to the Sharepoint site and change
their password to something unique? How do they do this?
(I need to send instructions and I can't find anything in
the MS documentation).
Thanks in advance for your assistance.
ard Tag: Good Reference Material For Share point Services Tag: 15207
sharepoint services, Lan
I have installed sharepoint services on a Small Business
Server 2003. I can view the companyweb website from the
desktop of the server itself at http://companyweb,.
However, I cannot access the website from the Lan. I have
tried using the general access of 192.168.1.105/companyweb
and it does not work.
I can however from 192.168.1.105 I can bring up the Welcom
to Windows Business Server 2003, to get started click a
link. This will not bring up the companyweb site either.
Does anyone have any ideas on how to make this companyweb
page work in a lan situation? I have established user
permissions which at this startup point are all
administrator priviledges and have added the network
computers to the server.
Thank you in advance for your help..
Jchelgren Tag: Good Reference Material For Share point Services Tag: 15195
changing the default view of a webpart page
Hi,
Is there any way to enforce a default view for newly created sites (if this
affects previously creates sites too, all the better) to have a default page
view of "personal" rather than "shared"?
Cheers,
- Oisin Tag: Good Reference Material For Share point Services Tag: 15194
Help adding spreadsheet web part
Hello,
I added a web component to our wss site. When I configure it to connect
to our database (just trying to connect to Northwind) I get the following
message in design and run mode. Any help would be greatly appreciated.
Message: Safety settings on this machine prohibit accessing a data source on
another domain Tag: Good Reference Material For Share point Services Tag: 15187
Urgent: Liscenseing Question
Is it legal for me to use WSS as a extranet and have clients (not employees
of the company) as well as employees use the WSS server. Or do I have to
buy the full blown Sharepoint Server? Tag: Good Reference Material For Share point Services Tag: 15180
Selecting multiple values from Lookup
Others have asked the question to no avail, but I will try again...
Is there any way to alow selection of multiple "lookup" values for a column
in a list?
I would like to be able to select multiple values from a lookup of Members
to assign to a new list item.
I am not adverse to a little coding.
It would be really neat if I could filter the members list first as well. Tag: Good Reference Material For Share point Services Tag: 15178
sql statement for a DataView
Hi, everybody!
Environment: Windows Server 2003, Windows Sharepoint Services, SQL Server
2000, FP2003
The question I have regards the complexity of the SQL statement the DataView
webpart understands. Are there any additional requirements on this
statement? Take for example quite a complex statement like the one above.
I've got it by modifying the main part of the proc_FetchDocSearchResults
stored procedure in one of my content databases. (I'm trying to build a
search engine for the portal and I thought I could start the investigation
the easy way :-) The server has no problem in returning the set, but FP2003
chokes ("The data source does not contain valid XML data. The server for the
data source returned a non-specific error when..." ). Should the statement
be XML returning (for xml or something)? By launching a trace I can see that
it doesn't even reach the SQL Server.
Anybody... suggestions, hints, anything?
Thanks in advance.
Pax
******************************************
SELECT
NULL as c1,
NULL as c2,
NULL as c3,
Docs.DirName,
Docs.LeafName,
Docs.DocLibRowId,
Docs.ListId,
Lists.tp_Title as Lists_tp_Title,
UserData.tp_Author,
UserData.tp_Editor,
UserInfo.tp_Title as UserInfo_tp_Title,
Docs.TimeLastModified AS LastModified,
Docs.[Size],
Docs.Id AS ItemId,
Docs#CT.Rank AS CT#Rank,
CASE WHEN (Docs.Type = 1)
THEN 3
ELSE 2
END as c4
FROM
STS_MyServer_1605625003..Docs
INNER JOIN
CONTAINSTABLE (STS_MyServer_1605625003..Docs, *, '"ss*"') AS Docs#CT
ON
Docs#CT.[Key] = Docs.ID
LEFT OUTER JOIN
STS_MyServer_1605625003..Lists
ON
Docs.ListId = Lists.tp_ID
LEFT OUTER JOIN
STS_MyServer_1605625003..UserData
ON
(Docs.ListId = UserData.tp_ListId) AND
(Docs.DocLibRowId = UserData.tp_ID)
LEFT OUTER JOIN
STS_MyServer_1605625003..UserInfo
ON
(UserData.tp_Editor = UserInfo.tp_ID) AND
(UserData.tp_SiteId = UserInfo.tp_SiteID)
WHERE
((Lists.tp_Flags IS NULL) OR
((Lists.tp_Flags & 0x400) = 0) OR
(UserData.tp_ModerationStatus IS NULL) OR
(UserData.tp_ModerationStatus = 0)) AND
((Docs.Type = 0) OR
((Docs.Type = 1) AND
(Docs.DoclibRowId IS NOT NULL)))
ORDER BY
CT#Rank DESC,
LastModified DESC,
ItemId ASC
****************************************** Tag: Good Reference Material For Share point Services Tag: 15176
Customizing sharepoint site
I am having a significant amount of problems trying to edit the default.aspx
page in frontpage 2003 of a top level sharepoint site (let alone any site i
create in sharepoint). I want to be able to modify what appears in the
quick launch and i keep getting this error that says the page cant be
displayed because it contains a web part that cannot be considered safe.
The KB article on MS site didnt help. Any ideas?
Garrett Felix Tag: Good Reference Material For Share point Services Tag: 15175
SQL cluster search problems - this may help
There have been occasional postings from people who have had problems with
performing searches within WSS sites when their databases are running on a
SQL cluster. For some people, if they have been using SPS, they have found
that the searches work at the portal level but not at the site.
It is important to understand that WSS searches are conducted using the
fulltext indexing capability of SQL Server, whereas the portal search
capability works in a very different manner.
I too have had the problem outlined above and, with the assistance of
Microsoft PSS, got to the bottom of the problem. I am sharing this solution
with everyone in case it helps. Your mileage may vary - your symptoms may
not match exactly and so the solution I'm going to give may not solve your
problem.
The steps we went through were:
* Check that Microsoft Search service is installed. This is listed in the
Services control panel applet. If it isn't listed, it hasn't been installed.
It was already installed on both of my nodes.
* Check the output from SELECT
fulltextserviceproperty('IsFulltextInstalled'). If you get "1" back, SQL
believes that the service is up and running properly. If you get "0", it
isn't. In my case, it was working when I migrated the cluster service group
over to node A, but it didn't work when it was on node B. For reasons I
won't go into, I was using node B by default.
The next steps were to try to spot the differences between the two nodes. I
was asked to check the following:
1) Make sure the below registry are the same between two nodes:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH
2) Make sure the DLLs are with the same version in the below folders:
\Program Files\Common Files\System\MSSearch
\Program Files\Microsoft SQL Server\80\COM
\Program Files\Microsoft SQL Server\MSSQL\Binn
3) Register the below DLLs:
\Program Files\Microsoft SQL Server\MSSQL\Binn\SQLFTQRY.dll
\WINNT\CLUSTER\GATHERCL.DLL
\Program Files\Common Files\System\MSSearch\Bin\*.DLL
Step (1) may reveal some differences if you've got service groups that are
one node but not all of them. This was so in my case, but the majority of
the registry keys were identical.
Step (2) is a bit daunting because of the number of DLLs involved. It may
help to remember that if you change the window display to "Details", you can
then customise the columns to include the file version, thus making it easy
to compare.
I did find some DLL differences:
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
sqlftqry.dll - 2000.80.760.0 (was 2000.80.194.0)
ssmsgnet.dll - 2000.80.382.0 (was 2000.80.194.0)
C:\Program Files\Microsoft SQL Server\80\COM
cnv6x70.dll - 2000.80.760.0 (was 2000.80.194.0)
sqlfth75.dll - 2000.80.760.0 (was 2000.80.194.0)
I copied those over and then went through step (3). This is done with
regsvr32. For some of them, I got an error - DllRegister Server entry point
was not found - but PSS said this was OK.
After all that, I move the service group from node B to node A (the working
node) and then back again. I then used the SQL query and confirmed that it
was returning "1" to indicate that fulltext was working.
Finally, I went into SharePoint, turned off full text indexing and then
turned it back on again. After waiting for a short while, I performed a
search in a WSS site and it worked!
I hope the above helps some of you. I would reiterate that your mileage may
vary. If you have got Software Assurance with either your SQL Server licence
or your SharePoint Portal Server licence, you may be able to take advantage
of online support through the Software Assurance benefit. This is what I did
and I'd like to thank PSS for their help with the above problem.
--Philip Tag: Good Reference Material For Share point Services Tag: 15170
WSS or STS in open source
Hello,
Is there any open source systems having same functionalities as STS or WSS.
Thank's for your answer.
Regards, Tag: Good Reference Material For Share point Services Tag: 15168
Info - WSS FAQ site additions and changes 3rd - 10th August 2004
Note: All of the addresses of the KB / MS / Non-MS Articles below were valid
at the time I added them to the WSS FAQ site and to this file. I can't
guarantee that they still are.
(This is also posted to my blog at (feed) http://mikeswss.blogg.de/rss.xml
(site) http://mikeswss.blogg.de) where you'll also find earlier versions)
(Items are added to the WSS FAQ throughout the week so you will find new
items more quickly by checking there daily.)
From 3rd August - 10th August 2004
I. KB Articles
A. New:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;873013
How to pass parameter information to format a Data View Web Part by using a
Web Part Connection with FrontPage 2003 (ver 1.1)
3rd August 2004
B. Modified
http://support.microsoft.com/default.aspx?scid=kb;EN-US;870853&FR=1
Office 2003 documents open read-only in Internet Explorer (ver 2.0)
6th August 2004
II. MS Articles
New
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office07012004.asp
The Definitive "Hello World" Web Part Tutorial
1st July 2004
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/aspnet-meetwebpartfrmwrk.asp
Meet the Web Part Framework
1st October 2003
III. Non-MS Articles
http://www.bluedoglimited.com/SharePointThoughts/ViewPost.aspx?ID=63
Using HTTP compression with SharePoint
4th August 2004
IV. WSS FAQ additions
http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=285
III.70 I'm importing contacts from a contacts folder I created in Outlook
but only some of the contacts are being imported. Why not all?
http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=286
III.73 How do I remove the header line from a List on the home page?
http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=287
III.88 My Browser crashes when I access a SharePoint site (or I have just
accessed a SharePoint site). Do you have a solution ?
http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=288
III.89 Weird things happend after I convert a page including drop-down menu
field to an XSLT Data View. How do I clear this?
http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=284
VI.09 How do you quickly get a Debuggable/Deployable web part up and
running?
V. WSS FAQ amendments
http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=95
III.21 I get ""HTTPException (0x80004005) Debugging is not supported under
current trust level settings". What do I need to do to activate debugging?
http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=279
III.87 Users who are listed as having access to a site are being prompted
for name/password and then rejected when they access the site. Any ideas
what might be causing this?
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup Tag: Good Reference Material For Share point Services Tag: 15167
Re: PivotChart WebPart Sorting
Further to this, whats wierd is that in the Office Pivot Table and the
Office Spreadsheet Webparts if a data column is date you are allowed to
format it (i.e. you can say mm/dd in the number field), the Pivot Chart
doesnt let you? Tag: Good Reference Material For Share point Services Tag: 15160
How to mirror/sync docs folder on WSS site?
Hi,
I'm looking for a nice folder mirroring proggie that will allow me :
1. Mirroring my documents folders on the sharepoint site.
2. In a way that just download the updates = syncing with the local
dirs on my computer.
Anyone might know of a specific tool that works good with it ?
All replicator/synchoniser/backuppers proggies don't work - they just
can't recognize the web folders of sharepoint in "my network places".
iOra and DocAve aren't suitable as well as they are for servers. I'm
using sharepoint hosting services on a 3rd party server.
Thanks Tag: Good Reference Material For Share point Services Tag: 15156
Re: MS Access informatio in SPS/WSS
Tough one,
Easisest approach I know would be to import the data to a SharePoint
List Tag: Good Reference Material For Share point Services Tag: 15155
Re: Add users to WSS using web services
The exception you are getting is a generic one that SharePoint reports
for almost everything.
To add users you would have to have admin rights (or permissions to add
users) on the site, so your webservice would have to use impersonation
to impersonate the user (who has rights) accessing the webservice. Tag: Good Reference Material For Share point Services Tag: 15154
Frontpage 2002 Sharepoint Template
Hi
I would like to use the Frontpage 2002 Sharepoint
template to develop our intranet site.
Our server is Microsoft Server 2003
I realise I need to get Windows Sharepoint Services
configued on this server.
50% of our staff are located around NZ and connect via a
VPN to our network.
My questions:
The reason I choose this template is my understanding
that I get Sharepoint functionality for free (well
almost) as my understanding is I do not need a licence to
use this template. My understanding is that I do not need
a Server 2003 External Connector License as our "external
staff" will logon to our network (where the intranet will
sit) via a vpn - is this correct?
Also, a cooleague sent me this link
http://www.microsoft.com/windowsserver2003/techinfo/sharep
oint/trial.mspx
My understanding is that after the trial period I would
have to pay to use Sharepoint this way? Whats the
difference between using the Frontpage template and using
Sharepoint as provided by the link?
Many thanks - the different Sharepoint options are
confusing me a bit as I'm not understanding why one will
cost but not the other.
Many thanks Tag: Good Reference Material For Share point Services Tag: 15153
Re: PivotChart WebPart Sorting
Out of a requirement the category column is dates and it is required
to only show mm/dd, therefore the constructed view on SQL Server is a
char showing mm/dd, when this comes to pivot chart, it messes up the
entire order by sorting it.
Your thoughts? Tag: Good Reference Material For Share point Services Tag: 15152
REPOST: IIS 5.0 Isolation Mode & SharePoint
I upgraded a W2K server to W2K3. It functions
pretty much as a web server. I tried to install WSS and it told me I had to
turn off IIS 5.0 Isolation Mode. So I did an all the other sites on the
server (there are 4 others) all are asking for a username and password. I
turn it back to IIS 5.0 Isolation Mode and the sites are fine. Any ideas?
Bob Tag: Good Reference Material For Share point Services Tag: 15151
Can not create ASP.NET web applications after insalling windows share point services
I have installed windows share point services to create some web parts
for my share point team site.
Today I tried to create an ASP.NET web application and got this error:
Unable to creat Web Project 'WebApplication1'. The file path
'c:\inetpub\wwwroot\WebApplication1' does not correspond to the URL
'http://localhost/WebApplication1'. The two need to map to the same
server location. HTTP Error 404
Can someone help me here.
Thanks a lot in advance. Tag: Good Reference Material For Share point Services Tag: 15147
Internet Explorer and Office Integration
I have IE 6.1 and all security patches installed. I have Office 2003
installed. I am using Outlook 2003/Exchange 2003 for email. When I access
my newly created Sharepoint 2.0 site and try to upload Contacts IE complains
that I do not have an address book compatible with Windows Sharepoint
Services and Internet Explorer 5.0 or greater. When I try to Edit
documents with Word 2003 IE complains that I do not have a Windows Sharepoint
Services compatible application and Internet Explorer 5.0 or greater. Since
I have both does anyone have any idea how to tell IE that? Tag: Good Reference Material For Share point Services Tag: 15146
Hi All:
Looking for a good back or good solid detailed, tutorial
type white paper on share point services. May be you can
recommend a short class.
>-----Original Message-----
>Hi All:
>
>Looking for a good back or good solid detailed, tutorial
>type white paper on share point services. May be you can
>recommend a short class.
>
>Thanks
>.
>
Thank you
>/Magnus Heuman
>
>>-----Original Message-----
>>Hi All:
>>
>>Looking for a good back or good solid detailed, tutorial
>>type white paper on share point services. May be you can
>>recommend a short class.
>>
>>Thanks
>>.
>>
>.
>