Cannot Resolve Collation Conflict

Collation can be defined at column level in MS SQL Server. An annoying error that comes up when using two columns that have different collations defined.

Informatica Admin Console not working.

  After installation of Power Center 8.xxx Cannot start Admin Console. It hangs on the following local address. http://localhost:6001/adminconsole.   and after sometime it shows the annoying error of  “Page not found”. I have checked the Informatica Services are up and running but my admin console does not come up. What to do now?   [...]

The maximum report processing jobs limit configured by your system administrator has been reached.

call Close or Dispose method at the end so the reporting engine remove the report entry from its queue.

The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first

This annoying error comes up when using some smtp server that uses SSL. A simple implementation to configure smtp settings in an ASP.NET web application is to add these setting in the specific "MailSettings" tag of Web.config file. I had also declared all the settings in web.config file but still I get this every time [...]

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154

Sometimes when working with office Interop assemblies the above mentioned error occurs. I had also got the same when using Microsoft Excel interop assembly and adding its reference in my ASP.NET application.       The problem is that by default when Microsoft Excel is used as a COM object then it can only be [...]