Windows Live Mail Error ID: 0x800C0148; Protocol: SMTP; Port: 0; Secure (SSL): No <— error prompts in Windows Live Mail after installation of IE8

After the installation of Internet Explorer 8 on my Windows Server 2008 (64-bit), my Windows Live Mail starts to prompt the following error, while the mail folders sometimes disappear.


===== Error =====


(Some errors occurred while processing the requested tasks. Please review the list of errors below for more details.)


An unknown error has occurred.


Windows Live Mail Error ID: 0x800C0148


Protocol: SMTP


Port: 0


Secure (SSL): No


image


And sometimes, the error dialog just pop up without stating specific error!


image


===== Solution =====


[1] The {Port: 0} error in Windows Live Mail usually relates to anti-virus application, and thus, I tried to disable the email scanning feature of my anti-virus application… but, this cannot resolve the problem.


[2] I suspect that some of the registered interfaces of the DLL files are corrupted. I used REGSVR32 to register them again, and this seems to have resolved the problem. I do not know exactly which DLL is required this time, while here comes my list of REGSVR32 *.DLL…


regsvr32 actxprxy.dll
regsvr32 oleaut32.dll
regsvr32 urlmon.dll
regsvr32 jscript.dll
regsvr32 vbscript.dll


===== For more information =====


~ [Open in New Windows] and [Open in New Tab] commands do not work in IE8


http://msmvps.com/blogs/martinpoon/archive/2009/03/20/open-in-new-windows-and-open-in-new-tab-commands-do-not-work-in-internet-explorer-8.aspx

SSMS – Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft .VisualStudio .OLE .Interop .IServiceProvider’. Exception from HRESULT: 0x80004002 (E_NOINTERFACE))

I am working on Windows Server 2008 SP1 Datacenter Edition 64-bit, with SQL Server 2008 installed.

After installing Windows IE8, I got the following error upon starting SQL Server Management Studio (SSMS) 2008.

===== Error 0x80004002 =====

SSMS – Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{6D5140C1-7436-11CE-8034-00AA006009FA}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)

image

===== Solution =====

After a bit of investigation, I found that the registry is somehow corrupted, and the solution is to re-register DLL.

~ Run [ Command Prompt ] (You will need to use the **Run as administrator** option)

~ regsvr32 actxprxy.dll

===== For more information =====

~ SSMS Object Explorer/Server Explorer Error

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20/

~ Windows Internet Explorer 8

http://www.microsoft.com/ie8

The module “actxprxy.dll” was loaded but the call to DllRegisterServer failed with error code 0x80070005

The module “actxprxy.dll” was loaded but the call to DllRegisterServer failed with error code 0x80070005.

image

===== Solution =====

Most probably, what you are trying to do is [ regsvr32 actxprxy.dll ].

For doing this, you will need to use a command prompt that is executed as administrator. So, grab your mouse… and

~ Right-click on the command prompt icon

~ Select [ Run as administrator ]

You may be prompted for administrator credential.

[ Open in New Windows ] and [ Open in New Tab ] commands do not work in Internet Explorer 8 RTW

So, I have installed Internet Explorer 8 on my Windows Server 2008 SP1 Datacenter Edition 64-bit, but… not that smooth. Somehow, something goes wrong somewhere, and I got the following problems after the installation of Windows IE8 RTW.


- In Windows Explorer (I mean those file explorer for browsing folders/files), when I double-click on a folder, a new Windows Explorer is popped up instead of (my default behavior is) showing the folder in the same explorer.


- In Windows IE8, when I right-click a web address on a web page, and then click [Open in New Window] or [Open in New Tab], the web page cannot be opened in a new window / tab.


- In Windows IE8, when I click a link on a web page that uses scripting to open a new window, the new window cannot be opened. (This is absolutely inconvenience as I need to use some kind of banking services immediately, while that bank uses JavaScript to open a new window.)


After investigating the problem for a while, I found that a registry entry was (somehow!) missing after the installation of Windows IE8, that relates to [ actxprxy.dll ].


===== Solution =====


Run [ Command Prompt ] (You will need to **Run as administrator**)


Type the following command. ( regsvr32 actxprxy.dll )


image


image 


All go smoothly!… and, I am now enjoying the much faster explorer engine.   :)


 


===== For more information =====


~ ‘Open in New Window’ command does not work in Internet Explorer


http://support.microsoft.com/kb/180176


~ Windows Internet Explorer 8


http://www.microsoft.com/ie8


 


===== Other posts that points here… =====


~ IE 8 slow? This tweak won’t help.


http://www.withinwindows.com/2009/03/29/ie-8-slow-this-tweak-wont-help/


~ Fix Broken and Slow Tab Issues in Internet Explorer 8


http://www.tweakvista.com/articles/39473/fix-broken-and-slow-tab-issues-in-internet-explorer-8/


http://tweakxp.com/article39473.aspx


http://tweaks.com/articles/39473/fix-broken-and-slow-tab-issues-in-internet-explorer-8/


http://www.tweakwin7.com/articles/39473/fix-broken-and-slow-tab-issues-in-internet-explorer-8/

Internet Explorer 8 RTW is released… make your web even better… faster, easier, safer

It’s soooo excited that IE8 RTW is finally released and is available in 25 languages! Let’s see how it goes beyond the RC1 version.

===== For more information =====

~ Download Windows IE8

http://www.microsoft.com/ie8

~ Windows IE8 fact sheet

http://www.microsoft.com/presspass/newsroom/windows/factsheets/IE8FS.mspx

~ IE8 deployment guide

http://technet.microsoft.com/en-us/library/cc985339.aspx

~ Microsoft Application Compatibility Toolkit

http://www.microsoft.com/downloads/details.aspx?FamilyId=24DA89E9-B581-47B0-B45E-492DD6DA2971&displaylang=en

~ IE8 Blocker Toolkit

http://blogs.msdn.com/ie/archive/2009/01/06/ie8-blocker-toolkit-available-today.aspx

~ IE Blog

http://blogs.msdn.com/ie/

~ IE @ MSDN

http://msdn.microsoft.com/en-us/ie/default.aspx

~ IE @ Microsoft TechNet

http://technet.microsoft.com/en-us/ie/default.aspx

SSIS – Converting string / numeric (yyyymmdd and hhmmss) to datetime inside Derived Column Transformation Editor

It takes me some time to figure out how a string / numeric value can be converted to a datetime value inside the Derived Column Transformation Editor of SSIS, and so, I would like to share my $0.20 here (in order to save others’ $0.20).   :)

Here, the original TradeDate (e.g., 20090316) and TradeTime (e.g., 230533) are numeric values.

 

This one returns a datetime value with TradeDate only.

(DT_DBTIMESTAMP)(SUBSTRING((DT_WSTR,8)TradeDate,1,4) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,5,2) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,7,2))

 

And here’s how I obtain the datetime value including both TradeDate and TradeTime. I intentionally use the function DATEADD() to add hour, minute, and second to TradeTime.

DATEADD("ss", TradeTime – ROUND(TradeTime / 100, 0) * 100, DATEADD("mi", ROUND(TradeTime / 100, 0) – ROUND(TradeTime / 10000, 0) * 100, DATEADD("Hh", ROUND(TradeTime / 10000, 0), (DT_DBTIMESTAMP)(SUBSTRING((DT_WSTR,8)TradeDate,1,4) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,5,2) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,7,2)))))

 

You may also concatenate both TradeDate and TradeTime into a string that can be read by DT_DBTIMESTAMP.

===== For more information =====

~ SQL Server Product Samples: SSIS

http://www.codeplex.com/MSFTISProdSamples/Wiki/View.aspx?title=SS2008!Execute%20SQL%20Statements%20in%20a%20Loop%20Sample%20Package&referringTitle=Home

~ Converting Strings to Dates in the Derived Column Component

http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.html

Microsoft Certification coaching sessions!… With certification promotion code ( HKEBA99B )

Are you ready for Microsoft Certification? Sign-up to join the following Live Meetings to help you have a better understanding of Microsoft Certification and the coaching sessions to prepare for your Vista and SQL 2008 exams.

Certification 101: Getting Started with Microsoft Certification. Learn about the value, benefits, and process of getting certified: choosing a certification path, preparing for your first exam, taking an exam, and what to expect at March 10, 2009 (Pacific Time) : 7:30 A.M. or 5:00 P.M. Pacific Time.

Microsoft Certification Coaching Session: Preparing for your Configuring Microsoft Windows Vista Client Exam (70-620) at March 17, 2009 (Pacific Time) : 7:30 A.M. or 5:30 P.M. Pacific Time

Microsoft Certification Coaching Session: Preparing for your Microsoft SQL Server 2008, Implementation and Maintenance Exam (70-432) at March 24, 2009 (Pacific Time) : 7:30 A.M. or 5:30 P.M. Pacific Time

The good news – when you are ready to take the Microsoft Certification Exam, go to www.learnANDcertify.com by March 31, 2009 and key in the HKEBA99B to obtain a 10% discount on your next Microsoft Certification Exam plus free retake if you fail plus the US$35 offer on eLearning. You will receive an email with the exam voucher code and a eLearning Promotion Code. Both offers will be valid till June 30, 2009. Happy Certifying…

 

Offer Details:

The certification promotion code ( HKEBA99B ) can only be used in Hong Kong.

The Offer is valid for a Microsoft Certified Technical Specialist (MCTS), Microsoft Certified IT Professional (MCITP) or Microsoft Certified Professional Developer (MCPD) exams. Not valid for Academic Exams.

Refer to the following links for applicable exams :
http://www.microsoft.com/learning/mcp/mcts/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/default.mspx
http://www.microsoft.com/learning/mcp/mcpd/default.mspx

Exam candidates must request an Exam Offer Voucher Code using the unique MVP Certification Promotion Code by March 31, 2009 via www.learnandcertify.com.

To receive a 10% discount on the cost of an applicable Microsoft Certification exam, exam candidates must use the Exam Offer Voucher Code provided by an MVP when they register for an exam and sit for an exam by May 31, 2009.

Limited to one (1) exam at 10% discount with a free retake (if necessary) per individual. Both exams must be taken by May 31, 2009.

The Exam Offer Voucher Code may not be combined with other vouchers or discounts and are void if altered or revised in any way.

Refer to http://learnandcertify.com/Terms.aspx for complete Terms & Conditions of Exam Voucher usage.

Are You Certifiable? Compete in the ultimate Tech IQ Challenge!… With certification promotion code ( HKEBA99B )

Looking to test your expertise?  If you’re an IT pro or a developer considering certification, or if you simply want to sharpen your skills, then you may be interested in checking out “Are You Certifiable?”, a new online game from Microsoft and Fuel Industries.

The game takes the form of a trivia show, but includes a broad range of technical questions geared towards one of two disciplines:  Developer, or IT.  Some of the questions appear to be taken straight from the pages of Microsoft Certification, so it looks like a good primer for someone preparing to take a MS Certification exam.  Also, stay on the look out for “rogue” questions, usually in the form of trivia (does anyone know who invented the mouse?). Choose a character, select your field of expertise, and pit yourself against the entire online tech community in a quest for Tech IQ supremacy, a top spot on the leaderboard—and ultimate bragging rights.  

Check out the game at www.areyoucertifiable.com . The good news – when you are ready to take the Microsoft Certification Exam, go to www.learnANDcertify.com by March 31, 2009 and key in the HKEBA99B to obtain a 10% discount on your next Microsoft Certification Exam plus free retake if you fail plus the US$35 offer on eLearning. You will receive an email with the exam voucher code and a eLearning Promotion Code. Both offers will be valid till June 30, 2009. Happy Certifying…

 

Offer Details:

The certification promotion code ( HKEBA99B ) can only be used in Hong Kong.

The Offer is valid for a Microsoft Certified Technical Specialist (MCTS), Microsoft Certified IT Professional (MCITP) or Microsoft Certified Professional Developer (MCPD) exams. Not valid for Academic Exams.

Refer to the following links for applicable exams :
http://www.microsoft.com/learning/mcp/mcts/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/default.mspx
http://www.microsoft.com/learning/mcp/mcpd/default.mspx

Exam candidates must request an Exam Offer Voucher Code using the unique MVP Certification Promotion Code by March 31, 2009 via www.learnandcertify.com.

To receive a 10% discount on the cost of an applicable Microsoft Certification exam, exam candidates must use the Exam Offer Voucher Code provided by an MVP when they register for an exam and sit for an exam by May 31, 2009.

Limited to one (1) exam at 10% discount with a free retake (if necessary) per individual. Both exams must be taken by May 31, 2009.

The Exam Offer Voucher Code may not be combined with other vouchers or discounts and are void if altered or revised in any way.

Refer to http://learnandcertify.com/Terms.aspx for complete Terms & Conditions of Exam Voucher usage.