ClevelandDotNet

Listed below are the answers to some of the questions posed at the August SIG meeting about SharePoint 2003. Q: For a web part that displays Outlook contacts in a SharePoint site, will it require Exchange? A: If you use "My Inbox" and tweak it a bit to point to any mail folder in your Exchange mailbox. (e.g. https://exchange.mycompany.com/exchange/1602/contacts/ ) In this case, it does require Exchange. On the other hand, there are special list types called Contacts Lists built-in to SharePoint. These are not integrated directly with Outlook. The data sits in the SharePoint SQL database. However, there is an option to "Link to Outlook". This gives you a link to the SharePoint Contacts list from your Outlook client. You can also import contacts from Outlook into the SharePoint contact list. In both cases, Exchange is probably not required, but this has not been tested. Q: How do you deploy an application from QA to production? A: First, build a CAB file to conta...

Problem : If you start Visual Studio .Net 2003 and get the following error: " Visual Studio .Net has detected that the specified web server is not running asp.net version 1.1, You will be unable to run ASP.Net Web Applications or services " There are several ways to go about fixing this error. Solution : From "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322" , run "aspnet_regiis.exe -r". The following messages will appear Start replacing ASP.NET DLL in all Scriptmaps with current version (1.1.4322.0). Finished replacing ASP.NET DLL in all Scriptmaps with current version (1.1.4322.0). When execution has completed, you can start VS.Net and load a web application without any problems.

To pass a variable from one web page to another page, use Response.Redirect() method( Response.Redirect("newpage.aspx?variablex=newvalue") ) to pass a variable to a newpage.aspx. In the receiving page (newpage.aspx), use the Request.QueryString() function to extract the variable desired ( Dim strPassed As String = Request.QueryString("variablex") ). When executed, the value of strPassed will be "newvalue".

I found a great article ( http://support.microsoft.com/kb/326340 ) on microsoft.com that provides click-by-click instructions on how to authenticate users logging into a web application against Active Directory. The article is complete and easy to understand, but misses to mention 2 crucial points. Within Login.aspx, you need to specify "Imports MyApp .FormsAuth". This will import the FormsAuthAD Namespace, otherwise declaring a variable of type "LDAPAuthentication" will result in a compile time error. Also, if you cut & paste the code, be sure that any references to "FormsAuthAD" are changed to the name of your project. This will ensure you import the correct class from the correct assembly. Aside from these points, the article is nicely written and easy to understand.

Q: Is there a way to store the time zone value in a datetime field in SQL Server? I receive the value of ‘12/1/2005 12:31:23 -5:00’ and when I try to store it in SQL it fails. Do I need to format the date/time differently, or I am forced to create a separate time zone field? A: SQL Server does not support storing a timezone in a datetime field. However, to overcome that issue, you can convert all date/time values to the UTC timezone so you have a standard timezone to work with. When displaying the data to the user, you would then convert the time to the client’s timezone. In regards to storing the value ‘12/1/2005 12:31:23 -5:00’ into SQL Server, try using the format '2005-08-09 00:00:00.000'.

LibCheck.exe is a free utility from Microsoft that allows you to compare two versions of an assembly, and determine the differences. The tool reports the differences as a combination of 'removed' and 'added' APIs. This can be useful in resolving versioning issues and determining which libraries are needed for a particular application. For more information or to download LibCheck, go to http://www.microsoft.com/downloads/details.aspx?familyid=4B5B7F29-1939-4E5B-A780-70E887964165&displaylang=en

I came across an interesting article on MSDN ( http://msdn.microsoft.com/coding4fun/diy/usingx10/default.aspx ) that turns an ordinary home into a smart home. Using an X10 device, one can turn on/off lights and devices remotely. In addition the X10 device can be interfaced with a PC and controlled using PERL script or .Net code. This also means you can control devices in your home through a VPN connection or a simple email. The MSDN article also contains a 15 mintue how-to video that shows the X10 in action. To take it a step further and interface with .Net code, Tony Northrup wrote "Home Hacking Projects for Geeks" ( http://www.homehacking.com ). This book discusses coding .Net projects for home control. Links to sample chapters are available on the left margin of the page.

Microsoft has recently published 30 new SharePoint applications, available for download. This is a testament to how versatile SharePoint is and how well it applies to every business. All applications and templates are available for download at http://www.microsoft.com/technet/prodtechnol/sppt/wssapps/default.mspx . This month's SIG meeting will be discussing SharePoint 2003 and it's many uses. The meeting is scheduled for Tuesday, August 23, 2005, 6:30 PM - 8:30 PM. It will be held at Cuyahoga Community College (Corporate College Campus - 25425 Center Ridge Road, Westlake, OH 44145) room 211.

I came across the SitePal web site and thought it was very cool. Once you subscribe to the service, you can choose an animated character that would read your web site or portions of it to your users. This helps to hold the attention of users so you eventually get more increased traffic to your site. The speech is very fluid and character movement is very realistic. Absolutely no programming knowledge is required to use SitePal. However, SitePal does interface with various programming languages for those who are technically inclined. For more information, check out http://www.sitepal.com

Linked Server is a feature in SQL Server that allows access to other databases, similar to accessing a SQL Server DB. As the name suggests it "links" to other servers, either other SQL Servers or other DBs on non-windows Servers (i.e. Oracle, DB2, etc.). The easiest way to create a Linked Server is through Enterprise Manager. In the left pane, expand the objects down to the desired server, where the Linked Server will be created. Expand Databases of the desired server and click on the "Security" Folder Right Click on "Linked Servers" and select "New Linked Server". Specify all the parameters for the server to be linked to. After a Linked Server has been created, it should be accessed using a four-part name syntax (see http://clevelanddotnet.blogspot.com/2005/07/what-is-four-part-name-in-sql-server.html for more information.)

DMP (Data Protection Manager) is a new Microsoft product to aid with data backup and restore operations. The latest beta version for the 2006 version was recently released to the public. To read more about DPM and download the beta, go to http://www.microsoft.com/windowsserversystem/dpm/default.mspx .

Intel’s Early Access Program (EAP) was designed to support independent software vendors (ISV’s). If you are not an ISV, the Intel Software Developer Network http://www.intel.com/cd/ids/developer/asmo-na/eng/index.htm will be a good resource for you. Listed below are the benefits of EAP. The Early Access Program www.intel.com/ids is Intel Developer Service's comprehensive web-based resource, helping developer’s take advantage of the processing power available from cutting-edge Intel processors. Some of the highlights include the use of a next generation development system, software optimization tools, training courses, technical support, business development, marketing and promotional activities. Please look over the website as it goes into greater detail about the opportunities, as well as the advantages of being in the program. Costs associated with the Early Access Program: There is an annual membership fee of $500.00. ISV’s can register for EAP by following these steps belo...

Q: I’m developing a web application for a client. I wanted to ask if it’s possible to integrate with SharePoint to authenticate users through the SharePoint site and then link to the web app with those credentials? A: Yes, it's definitely possible. Usually SharePoint is setup with Integrated authentication in IIS. If your web app uses the same login/password to access the app, then these credentials can be "passed through" to the app from SharePoint. Just setup your app virtual directory to have integrated security. Also, here are some things to consider: 1. Do you want the "application" to run within a SharePoint page? Maybe consider writing a .NET web part then. 2. Do you want the "application to run within the context of SharePoint (access to the SharePoint object model)? Then you have to put the app in a specific vdir location (_layouts folder) in order for it to work with SharePoint. This is documented in the SharePoint SDK. 3. Is the app running ...