All Things Microsoft AI

Listed below are click-by-click instructions for creating a document library, making it a trusted location, and using it to display an Excel 2007 spreadsheet via Excel 2007 web part. Create Document Library (with Excel as the default type) 1. Open the Home page to your site collection (i.e. http://moss101/Pages/Default.aspx ) 2. Click “View All Site Content” 3. Click "Create" 4. Click "Document Library" 5. Specify all the settings for the library, using Excel 2003 as the default type. For the sake of this example, the document library will be called “Warehouse Documents”. 6. A document library called "Warehouse Documents" is now created, accessible at http://moss101/Warehouse%20Documents/Forms/AllItems.aspx Make it a trusted location 1. Click "Central Administration" 2. Click "Shared Services Administration" 3. Click the Shared Service (i.e. "SharedServices1(Default)" ) 4. Click "open Shared Service Administration" 5...

For those with projects utilizing SQL Server 2000, Microsoft issued End of Life dates for support. Mainstream Support End of Life - April 8, 2008 Extended Support End of Life - April 9, 2013 End of "free" support Hot fixes (non-security related) will require an extended hot fix support agreement to be purchased Microsoft will not support warranty support, new features, or design changes Security updates will continue to be provided Microsoft Support Lifecycle: http://support.microsoft.com/lifecycle/ MS SQL 2000 Lifecycle: http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=9&y=11 With the retirement of SQL Server 2000 around the corner, this brings up an interesting question for MCAD/MCSD candidates: Will this impact certification Exam 70–229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition? When will the exam be retired? Given Microsoft is still promoting the MCDBA certification on their site, I'm guessing 70-229 ...

Office 2007 presented users with a new easy to UI, utilizing the new ribbon interface. However, not all users are comfortable with the new UI. A new ribbon customizer tool is available for Office 2007 providing a similar look and feel as previous versions of Office. To preview the ribbon customizer, go to http://pschmid.net/office2007/ribboncustomizer/featuretourpart3.php . A trial download version is also available.

This is an interesting article on debugging stored procedures, showing click-by-click directions. To view the full article, click here . In addition, another link was posted on this blog previously at http://clevelanddotnet.blogspot.com/2007/05/follow-up-questions.html .

String manipulation in VB2005 is fairly simple. However, things can get a little tricky with the double quote character. How do you look for it in a string? How can you insert into a string? How do you remove it from a string? These are questions that may lead to confusion if you don't know what you're looking for. Ironically enough, in VB the double quote can also be used as an escape character when searching for it in a string. For example: Dim strTest As String strTest = """123""" 'Displays "123" (double quotes appear in the final result) strTest = """""123""" 'Displays ""123" (double quotes appear in the final result) strTest = "test\""test" 'Displays test\"test strTest = "test""test" 'Displays test"test In cases where you want to insert a double quote character, simply reference it unicode character designation, ch...

Listed below are some questions and answers from the last user group meeting. Q: I have alot of VBA experience and would like to learn VB.Net. What resources are available that can help with this? A: There are several sites available online to assist with this. For starters, check out the following links: http://msdn.microsoft.com/vstudio/express http://msdn.microsoft.com/vstudio/express/beginner http://safari.oreilly.com http://www.bookpool.com http://www.nerdbooks.com Q: I created an application as a web site. Is there difference in deploying it between a web site application and a web project application? Is there any way to deploy it as a web site application? A: ASP.Net 2.0 "web sites" are different from the "web projects" you worked with in VS2003. Deploying a web site in VS2005 requires a different procedure (see http://www.odetocode.com/Articles/417.aspx for more information). If you want to build and deploy web applications in VS2005 the same way you d...

Listed below are follow-up questions from our last user group meeting on DotNetNuke. Q: What are the System Requirements for DNN? A: Win2003 server, IIS, ASP.Net 2.0 Q: Does DNN install as a "web-site" or does it take over IIS? A: DNN installs as a simple web site application. Installation in simple, and by Default it installs with SQL Server Express. Q: Can DNN sites be crawled by internet search engines? A: DNN sites can be crawled. The menu actually checks the HTTP user agent string to see if a spider is hitting the site and presents an alternative menu to make it easier for the spider to crawl the site. Q: Is everything stored in the DB, much like SharePoint? A: Most items are in the DB, much like SharePoint. Some organizations do DB migrations to move all content. There are some .JPG files or other resource files that are not stored in the DB directly. For the most part, everything is stored in the DB. Q: Can SharePoint or ASP.Net 2.0 web parts be incorporated into D...