Answer Questions
sliderhouserules Scalable Windows services
Hi, We have a WIndows Services app with the following layers: 1. DAL 2. BLL 3.Windows Service To give maximum scalability , availability and performance for this application, what are steps that we would need to take Is it recommended that the Windows Service application be load balanced Thanks. Lakshmi It depends more on what the windows service is doing and how frequently it is starting the process whatever it is intended to do and how long each process take... you also mentioned that it is using DAL and BLL... where is the database Is it running on the same server (or computer) where the windows service is running or making a connection to the database on a remote computer on the LAN or WAN From the windows standpo ...Show All
chrisc12345 Images in Wikis
Is it possible to paste images into a Wiki We tried to copy content from a Word doc that contained some screen shots and paste it into a Wiki. None of the images copied over. What happens is the text copies over fine, but it does not copy over the images. It just leaves a blank where the image should be. Any ideas Hi all, We used to be able to use the "Save as Web Page Filtered" trick to save word docs directly into the Wiki, but lately it no longer works and all the documents previously converted that way now have bad image links instead of images. Any idea what chagned, or what our IT folsk mgiht have chagned to cause this Thanks, Eric- It' ...Show All
bbusacker What is the difference between Convert.toString and .toString()
What is the difference between Convert.toString and .toString() Just to give an understanding of what the above question means seethe below code. int i =0; MessageBox.Show(i.ToString()); MessageBox.Show(Convert.ToString(i)); We can convert the integer “i” using “i.ToString()” or “Convert.ToString” so what’s the difference. The basic difference between them is “Convert” function handles NULLS while “i.ToString()” does not it will throw a NULL reference exception error. So as good coding practice using “convert” is always safe. Once again using the trusty reflector, the body of the Convert.ToString (object value) looks like this: public static string ToString(object value, IFormatProvider provider) { IConvertible convertible ...Show All
Part Time Australian Lookup task run very slow when hitting big tables
I try to convert a Procedure that join 8 tables with INNER AND OUTER JOIN, my understanding is that the Lookup task is the one to use and I should break these joins into smaller block, it takes a long time to load when I do this, since each of these tables had 10-40mill. rows and I have 8 tables to go thru, currently this Stored Procedure took 3-4min to run, by converting this to 8 Lookup tasks, it ran for 20min. has anyone run into this issue before and know a work around for this. Thanks This Is Right, But Slow Dear tm9t9 , I haven’t tried this (with 10 to 40 mil. rows) before, but according to my experience natural-join (just use “table1.row1 = table2 ...Show All
Carl Daniel How to connect to lists and libraries in another Site Collection
MOSS documentation states explicitly that I cannot do what I want to do, namely, create a data source connection to lists and document libraries in another Sharepoint site collection: "If the other site is in the same site collection, you can access all of the data sources in that site, including SharePoint lists and libraries. If the other site is in a different site collection, you can still access all of the other data sources, but not SharePoint lists and libraries." http://office.microsoft.com/en-us/sharepointdesigner/HA101191181033.aspx However, I'm in the process of setting up a corporate deployment following the model described under "Design Logical Architecture" in Microsoft's Technet book "Planning and Architecture for Offi ...Show All
TkNeo Development Approach
I have describe our approach below to building a new development SharePoint 2007 Infrastructure, can anyone give me some feed back/advice to this approach please make for good reading........ 1 Development Environment Topology We are using a small farm topology for our MOSS development environment. This will be configured as two separate (physical) dedicated servers; (1) web front end server (MOSS2007) and (2) SQL Server (SQL2005). This topology will run in a dedicated domain (e.g. ‘OffDev’), with trusts to our main company domain (i.e. to allow designated users to access the domain as required). Each physical host server will be configured to run a VM using Virtual Server. For example the we ...Show All
brian_tsim "Modified" column show changes, but no alert
Hi, We have a weird situation for all our files in Shared Documents. All newly uploaded document will be shown "Modified By" by userA. A new version is generated but no alert has been sent out. But alerts will be sent out for any other changes. UserA claimed no changes to the document. And there's no document approval. Is it possible to use UserA loginId to change the document without UserA knowledge and how May I know how to rectify this problem Appreciate any help. p/s: we are using wssv2 ...Show All
Ramanujam Sampath _layout pages and masterpage
Hi All, I'm a bit confused here. Is it true that modifying the application.master (which I don't want to do) is the only way to change the masterpage for the _layout pages in Sharepoint 2007 In fact changing all the files themselves is not an option either because it's not supported I was told. So how's the correct procedure to change the _layout pages from your sitecollection Fred Hello Fred, as i know this is the only option to set application wide master settings. Does someone else know about other possibilities Greetings, Marcel Nope, but I'd like to know that too. It's on the 'to learn' list. Themes are a part of ASP.NET 2.0, though, so they're not SharePoint specific ...Show All
arists Error in communicating with Excel Calculation Services
When attempting to view an Excel spreadsheet in SharePoint, we get the following error displayed in the web browser: Excel Web Access: An error has occurred Checking the Event Log we see: There was an error in communicating with Excel Calculation Services http://uklo2k3d02:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized. [Session: (null) User: CAPCO\jtnn]. The user has full admin rights over all systems We are running RTM version of SharePoint 2007, Enterprise Edition Excel Services is enabled, configured and activated on all levels. The location is set as trusted. The rest of the server works perfectly Shared Services wor ...Show All
Sameer123 Can you use Active Directory Manager data in workflow?
I can’t seem to find a way to automatically rout a workflow task to a user’s manager using the person’s "manager" value from Active Directory. This seems like such a basic task, but I don’t see any option for it in the workflow roles available in SharePoint or SharePoint Designer. Has anyone had luck with this I'm also very keen to learn how to achieve this. We will have several workflows that will require manager approval (eg. annual leave requests), so this is a biggie for us. Cheers, Matt I haven't been able to get it working in WWF directly, but using a secondary datasource in an infopath form and the MOSS UserProfileService web service(g ...Show All
N.Z. Bear MSMQ ping and timeouts
Hello, I am using MSMQ with a TCP network load balancer and I have two issues that I hope can be fixed by changing the configuration somehow. 1. If a computer needs to send and MSQM message, it first has to establish a TCP connection to the virtual IP at port 1801. Before it does that, however, it first sends a UDP "ping" packet to port 3527 . Then it waits 6 seconds for a reply that never comes and only after that it establishes the TCP connection. Is there a way to get rid of the ping or the 6-second waiting period Should I make the load blanacer forward the UDP message somehow 2. Could I force the sender the close the TCP connection after every single message sent I found an article that talks about this stuff: ...Show All
Duncan Woods Need a bit of help getting My Site functionality to work
Hi all. I have installed MOSS 2007 enterprise in a simple-server farm mode using a SQL 2005 backend. It appears I have everything else working except the My Site functionality. When I click on My Site, I get: Your personal site cannot be created because Self-Service Site Creation is not enabled. Contact your site administrator for more information. So then I enable Self-Service Site Creation for the web app that is hosting the My Site service and try again. This time I receive: There has been an error creating the personal site. Contact your site administrator for more information. I have the SSP set up so that the admin site is on one web app on a port other than 80, and the My Site is on a different web app at p ...Show All
NeederOfVBHelp Create Wiki page dynamically
Does anyone know if it is possible to create a new wiki page through code or sharepoint web services Not a new site collection, because this is possible through the admin web service, but rather one single wiki page belonging to a wiki site collection. I can't find any examples of this in the SDK or anywhere, all I can find is how to use the Add() method of the SPWebCollection object to create new sites, but they will be their own and not pages belonging to an existing wiki site... Any help is very appreciated. Hello, I am having problems with adding a wiki page dynamically. I've tried using the Add method of the SPFileCollection but still no luck. I've read that you were able to solve this problem. Can you just gi ...Show All
DavidR100 Design Question
We are designing a Enterprise web application. This application will be typical 3 tier application . With ASP.net in UI layer, BusinessLogic layer and Data Access Layer in C#. Database will be SQL Server 2005. My question is what advantages we can have if we place UI layer in separate physical server and BL and DAL in other server I am planning to use remoting in this context. I would also mention that layers were never designed to be distributed. What I mean by this is that a well designed interface between layers that run in-process on the same machine would probably be a terrible interface when run across machines. If you want to plan to scale out your software, you need to design the fr ...Show All
Jaime Stuardo Create a 'custom' List with Pages
Hi, I need to create a 'custom' List that will contain Pages (or articles if you want). I can't use the default Page list that's there. How can I go about doing this I need this because I have to have a List with articles that aren't shown on the site as other 'normal' articles. Thanks! I am dealing with the same situation. We need to create custom document libraries that support the Page content type. Apparently, you can define a custom ListTemplate and ListInstance using CAML and features. You can use the C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES\Publishing feature as a template for your custom document library. So far I have successfully created a new d ...Show All
