how to troubleshoot a COM+ exception

Guidelines to follow when crash of COM+ package happen on production environment

1. Don't close crash dialog with prompt to send file to Microsoft, therefore dmp file could saved into another location (details will provide file location) or consider to enable dump for COM+ package
2. Use WinDbg to analyze dump file - download symbols for system where crush happen

Problems:

• No symbol files available for msxml dlls
• Debug Diagnostic tools is old and didn't help, gives empty report
• How to debug crash from another operating system (like use XP to debug 2003)

Resources:

INFO: MTS/COM+ Events 4104 and 4194
http://support.microsoft.com/?id=291365

How to use ADPlus to troubleshoot "hangs" and "crashes"
http://support.microsoft.com/kb/286350/EN-US/

Windows does not save memory dump file after a crash
http://support.microsoft.com/kb/130536

Debug Diagnostic Tool v1.1
http://www.microsoft.com/downloads/details.aspx?FamilyID=28bd5941-c458-46f1-b24d-f60151d875a3&DisplayLang=en

hosting solutions

It is possible to have site registered with one company such as NETWORK SOLUTIONS and hosting available with another company for example easycgi.com

To do this is required to set Domain Name Servers information to follow new settings. In this case domain transfer is not required.

Hosting companies provides bundle with domain and hosting together. It have simplified registration process for end user.

References:

Domain name registrar
http://en.wikipedia.org/wiki/Domain_registrar

Link to hosting solutions:
http://www.gate.com/promos/index-FreeShirt.htm
http://www.easycgi.com/services/advanced.html
http://startlogic.com/
http://www.1and1.com

Free hosting solutions:
http://www.bravenet.com/
Bravenet free hosting accounts are limited to support of the following file types:
.htm, .html, .gif, .jpg, .png, .txt, .swf, .mid, .rmi, .au, .wav,
.js, .css, .ico, .bmp, .class, .dcr.
No database.

excel printing

Tips for fast updates and printing in automating of Microsoft Excel

1. Use ScreenUpdating property
Application.ScreenUpdating = False
' code here
Application.ScreenUpdating = True

2. Use ADO to update xls file - is much faster than updating cell by cell

3. Use cell array - is much faster than updating cell by cell

Save File to msaccess mdb

MSDN site provides example how to save picture ( could be any binary data file ) into SQL Server. No example has been provided for MSAccess, this database is not designed for such services.

Other references are:

ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs)
http://support.microsoft.com/kb/103257

How To Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
http://support.microsoft.com/kb/258038

HOWTO: Use the Picture Box in a UserControl and in a DataRepeater Control
http://support.microsoft.com/kb/250577

Web 3.0 as Read-Write-Execute Web

Web evolution could be recognized in next steps:

• Web 1.0 as "the Read Web"
• Web 2.0 as "the Read-Write Web"
• Web 3.0 as "the Read-Write-Execute Web"

This simplistic point of view does not pretent to express every part of huge variaties that could be found on Internet.

References:
Entrepreneurs See a Web Guided by Common Sense
http://www.nytimes.com/2006/11/12/business/12web.html?pagewanted=2&ei=5088&en=254d697964cedc62&ex=1320987600

Web 2.0
http://en.wikipedia.org/wiki/Web_2.0

Web 3.0
http://en.wikipedia.org/wiki/Web_3.0

Dapper
http://www.dapper.net/dapperDemo/index.php

Ghostwriter
http://en.wikipedia.org/wiki/Ghostwriter

Useful information for File operations

PRB ReadDirectoryChangesW Not Giving Consistent Notification
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q245214#appliesto

FindFirstChangeNotification May Not Notify All Processes on File Changes
http://support.microsoft.com/kb/188321/EN-US/

QuickWin - Turn a console application into a Windows program - The Code Project - Dialog and Windows
http://www.codeproject.com/dialog/quickwin.asp?df=100&forumid=1348&exp=0&select=683473

Event Logging, Part I XEventLog - Basic NT Event Logging - The Code Project - System
http://www.codeproject.com/system/xeventlog.asp