SHAREPOINTBlogs.com Mirror

Unable to connect to database.

The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. I keep getting this error in my error logs for our Test/Staging Portal. I'm unsure where its coming from. Any ideas? Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Using Business Data Catalog Definition Editor

Using Business Data Catalog Definition Editor Category: SharePoint Level: Beginner Business Data Catalog is a Microsoft Office SharePoint Server feature that allows users to access external data from within SharePoint. SharePoint, as we know, is an excellent collaboration portal that can be used to create robust collaboration applications using Office products. Good thing about the new SharePoint portal is that it also allows you to create applications that involve non-MS products and allows you...( read more ) Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Microsoft's SharePoint VPC: Successes and Failures

I thought I would get a dialogue going about Microsoft Trial SharePoint VPC. My new consulting company has me looking into it as a viable tools for proof of concepts and demoing purposes. Well, I have a few concerns. One, the VPC has a trial version of Visual Studio 2005, which the trial version does not install the templates for VS 2005 and does not have a command prompt for your use. Therefore, I try to install the templates for wss 3.0 but no templates are installed into VS 2005. So I can't build a web part(save for from scratch). I can't build a site definition or any of the like. I'm very discouraged by this discovery. I am currently attempting to get VSTA on the trial version to program with InfoPath 2007, but I am doubtful it will work... Please if anyone has attempted to use the trial vpc for such tasks and been successful or had the same luck as I have. Please post your comments here! Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

List does not exist. AccessDenied.aspx. I finally figured it out...

So this is an interesting issue. The problem that I was having to cause this error to come up was using the SPSite.AllWebs[Guid] collection to get the web that I wanted. Well, when the code is run under the impersonation of a user that doesn't have access to all of the webs, they run into the AccessDenied.aspx, List does not exist error. They aren't able to access the allwebs collection that the administrator can. So remember this, use the SPSite.OpenWeb(Guid) function instead! :) It will save you all kinds of trouble. Safe journeys in the world of SharePoint! Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

SharePoint BUG! Can't keep title of web part on list's form pages!

So if you create a list on a typical site in Sharepoint, you'll notice that the web part contained within does not have a title. Fair enough, wouldn't look great with one, but if you want to add a web part below that one, and keep this web parts title on the screen, you can't! I keep setting its web part properties to "Title only" and it keep switching back to "None" everytime in hit ok. I even tried to trick sharepoint by select apply and then cancel, but that didn't work either! I'm ready to cry, cause I promised my client a scripting solution that utilized the title of the web part as its identifier. If anyone has had any similar solution or found a work around, please let me know! Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Problem with Custom Web Part! Big issue!

Ok, so I can use this web part and it adds to the list just fine, but when my colleague with the same permissions to the list uses it, she can't get it to add to the list.... I implemented the run with elevated priviledges and used guids instead of using the spcontext.current(heard that negates the elevated priviledges) Any thoughts? private void PopulateDataset() { try { mySite = new SPSite(siteURL); try { myWeb = mySite.OpenWeb(parentURL); } catch { myWeb = mySite.RootWeb; } favList = myWeb.Lists[listName]; NAPWS.Service napService = new global::WPRecordSiteVisits.NAPWS.Service(); oDataSet = napService.SearchClients(); oView.Table = oDataSet.Tables[0]; } catch(Exception e){ lblError.Text += "| PopulateDataSet: " + e.Message; } } private void RecordSiteVisits() { try{ if ((HttpContext.Current.Request.UrlReferrer == null || HttpContext.Current.Request.UrlReferrer.AbsoluteUri.IndexOf(SPContext.Current.Web.Url) == -1) && (HttpContext.Current.Session["Referrer"] == null || HttpContext.Current.Session["Referrer"].ToString().IndexOf(SPContext.Current.Web.Url) == -1)) { if (HttpContext.Current.Session["Referrer"] != null) HttpContext.Current.Session["Referrer"] = SPContext.Current.Web.Url; string pathString = HttpContext.Current.Request.Url.AbsolutePath.ToString(); string strNC_Number = ""; if (pathString.IndexOf("NAP/") != -1) { pathString = pathString.Substring((pathString.IndexOf("NAP/") ...

Custom Web Part Building: State Management Tips and Tricks

When building custom web parts its essential to understand when controls will contain thier values and when they don't and how to keep variables that will contain their values throughout the web part life cycle. Especially if you would like to dynamically load one control based on another controls input. 1. In CreateChildControls, No control will contain a value, not even hidden fields. This eliminates some uses of a common practice of utilizing hidden field to maintain viewstate. 2. ViewState Parameters are great for maintaining values throughout the web part lifecycle. Initialize them in the constructor of a web part to avoid null errors. Initializing a view state parameter: ViewState["parameter1"] = ""; Retrieving a value from view state: string this = ViewState["parameter1"].toString(); 3. If you would like to maintain a web parts state while navigation persists in your website, you can utilize session state variables with the following code: Adding a variable to session state: HttpContext.Current.Session.Add("variablename1", "value1"); Retrieving a variable from session state: writer.Write("'" + HttpContext.Current.Session["variablename1"] + "'"); Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Roll over image thumbnail

Problem: I would like to have a list of small images in a document or picture library. These images when roll over should display the larger image in another box on the screen maybe a image web part. Currently I can do this with provide column option but it's not a roll over effect you have to click the little button next to the image to view it. Also the image web part have scroll bars on it. I do not want to have to resize and create thumbnails for every image. Is there a way to force the image smaller or larger to fit the forced pix on the image web part? Solution: Unknown Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

AllGroups.aspx hide groups to users

Problem: Security Groups show for all users. This is a security issue, but more importantly this show the clients Projects to other Projects and Clients. This is not OK. There needs to be an option for who can view the Group List. Solution: root/catalogs/users/AllGroups.aspx I set a filter that says you can only see the groups(works for user lists too) if you were the last person to modify the list or created the list. This allows for the System Account to see these lists but not users. Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Image Webpart no Slidebars

Problem: Image Web parts show slide bars when an image is bigger then the image web part forced size. I don't see a flag to turn this off. Solution: Unknown Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Thumbnail and Preview in Document Library

Problem: I need to add a thumbnail and preview to a photo's folder in a document library. I can do this with a image web part and add a connector from the photo list to the image web part. However, I am unable to find a way to shrink the photo if larger then the image web part if I force the web part to use pixel size control and not auto then I have scroll bars bottom and right. I check the HTML code and there don't seem to be any preexisting flags to stop these scrollbars. I would rather have all the options I had in the picture library. Because this client deals with contractors and clients that are not very tech savvy (Don't we all) I am forced to put all files into a document library and am unable to have a picture library because they are in different root folders. This seem like an over site from MS why can't I have Picture and Document folders in the sub off the main root link. Attached are some photos that should show what I'm talking about and how we are putting all these folders in the same place. What I've tried: I tried to copy the views from a Picture Library to the views folder of a document library to no avail plus none of the slide show or the all picture options didn't even showed up. Whatever I do I will have 20 to 30 of these sites, I need the solution to template. Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Known SharePoint Issue: Switching from inherited to custom permissions!

SharePoint has a known issue when you're working with the Security of SharePoint. When you are working with the permission in Sharepoint and want to go back and forth between inherited and custom security, MOSS 2007 gets mad. Breaks the entire portal. So if this happens look for this hotfix: http://support.microsoft.com/kb/937038 . And Safe Journeys in the world of SharePoint! Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

High Priority ISSUE! MOSS 2007 craziness! Problem!

Okay, I've got to explain this in a way that translates that shear nonsense that happens here. So I search web part taht search oracle for client ids, brings back the client id and sends it to a redirect page. The redirect page has a web part on it that grabs the client id from the query string and either creates a page for the client if none exists and then ships them to the page, or just sends them to the sharepoint page. On the client's page, There's quite a bit of custom functionality through the use of javascript and custom web parts... The client page is also given a query string "NC_NUMBER=346" to tell the page which client it is so the custom webparts can query oracle for some related info about the client. So thats the scenario. And this works perfectly on my computer and a couple other peoples computers, however, when certain end users try to get the client's page, they get a: "List does not exist The page you selected contains a list that does not exist. It may have been deleted by another user. " Now, this is nuts enough just if it happened when going through the redirect page, however, it does this if you attempt to open a new IE window and paste the url with the nc_number parameter. No redirect involved... AND THEN, check this out, if you go to the site, get the error message, and then hit go back to page, it will load the page no worries. What seems to occur on the users page, is the sharepoint pulls some query parameters out...

Discussion Boards Bug

Has anyone else had problems with the discussion boards? My end user will simply modify the view and end up causing problems with the entire list. The the default view will become the home page... And the links won't go to the threaded discussions, they will begin acting like folders... Anyone else had these types of problems? Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Using a Web Service as a Data Source in SharePoint Designer Bug

I can set up a web service as a datasource in Share Point Designer. However, when I attempt to pull that information into a drop down list list form control it does not populate with information. I've tried it several different ways, and paralleled it with a working model using a direct sql connection. I believe this to be an error with SharePoint Designer. Please comment with any related experiences. Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks