Jan 27 / kornelius

willkommen auf kornelius.org

Dies ist eine kleine Website über mich und meine kleinen Projekte.
Viel Spaß beim Stöbern.

kornelius

Share on Facebook
Dec 8 / kornelius

Ever wondered about translated excel function names?

If you ever searched for a excel function name (e.g. in German) pointed out in another language (e.g. English) you might had hard times finding. Here comes the solution. This nice page translates all function names in several languages.

http://wwwhome.cs.utwente.nl/~trieschn/excel/excel.html

Very helpful, even searchable.

Share on Facebook
Jul 4 / kornelius

View current requests in IIS 7

In IIS 6 I used IIS Tracer to view to current requests on my webserver. Running IIS Tracer on a Windows 2008 server x64 with IIS 7 it did not work. So I searched a bit and found this page: http://technet.microsoft.com/en-us/library/cc732518%28WS.10%29.aspx. It shows how you can monitor the current requests in IIS7 using build in features only. It is not feature rich as IIS Tracer, but a good alternative anyway.

Share on Facebook
Feb 28 / kornelius

korAccount 3.3.2.0 verfügbar

Die neue Version 3.3.2.0 ist online. Diese enthält eine neue subsembly-Version für den Kontoauszugdownload. Außerdem ist korAccount jetzt auch in Englisch verfügbar.

Share on Facebook
Feb 20 / kornelius

Problems with Drag&Drop and VMWare Workstation 7

Once again I had some trouble with drag&drop between the host and guest using vmware workstation 7. My host is windows 7 and the guest windows xp sp3. I don’t know exactly what fixed the problem in the end but here is what I did:

  1. Ensured the gust is running on 32bit color depth
  2. Uninstalled vmware tools, reboot, reinstalled vmware tools
  3. restart vmware-user process (on guest)
  4. restart vmware-tools service (on guest)
  5. Tried to disable drag and drop in the guest isolation (read this in some forum)
  6. Enabled drag and drop in the guest isolation options again
  7. Enabled VMCI in guest isolation page
  8. Shutdown the vmware guest system
  9. Restart -> fixed
Share on Facebook
Jan 6 / kornelius

Jahreswechsel mit korAccount

Ich erhalte einige Anfragen bzgl. dem Jahreswechsel in korAccount.

Der Jahreswechsel in korAccount ist absolut kein Problem. Neue Buchungen im neuen Jahr (2010) sind aber ggf. nicht sichtbar, wenn der Filter (oberhalb der Buchungsliste – in der Zeile des Suchfeldes) noch auf das Vorjahr (2009) eingestellt ist.

Die Lösung ist also einfach eine neue Buchung für 2010 anlegen und den Filter auf 2010 umstellen. Schon erscheinen die neuen Buchungen.

Share on Facebook
Jan 4 / kornelius

kornelius.org auf wordpress

Nach einiger Recherche und Ausprobieren, habe ich kornelius.org nun auf wordpress umgestellt.
Wordpress löst somit joomla 1.5 ab. Vorangegangen war ein Versuch mit Drupal, der aber an dem Communitysite-Ansatz von Drupal scheiterte.

Share on Facebook
Jul 2 / kornelius

Emails are not delivered if the body contains single line feeds

The eventlog on our SMTP Server under IIS6 reported the following error very often:

Source: smtpsvc
Category: none
Event ID: 4006
Description: Message delivery to the host ‘xxx.xxx.xxx.xxx’ failed while delivering to the remote domain ‘mydomainname.ext’ for the following reason: The connection was dropped by the remote host.
German: Die Nachrichtenübermittlung an den Host “xxx.xxx.xxx.xxx” ist fehlgeschlagen, während an die Remotedomäne “mydomainname.ext” übermittelt wurde. Ursache: Die Verbindung wurde vom Remotehost getrennt.

The following page brought me to the solution, even if I did not believe in it:

http://www.dylanbeattie.net/docs/iis6_bare_linefeed.html

In short: don’t have any bare linefeed chars in the message body. Just replace the \n with \r\n and it should work (be careful if you have both \n and \r\n in the body already).

Share on Facebook
Jul 2 / kornelius

CDATA Section removes all carriage returns

Using some CDATA values in a recent project I noted that the carriage return + line feed was not returned from the xml file using a XmlTextReader.
This turned out to be the expected behavior. That means, all CR and CRLF are replaced to LF.
My source was: http://bytes.com/groups/xml/87719-losing-carriage-returns-cdata-section-how-do-i-prevent

I ended up by replacing all returned values from \n to \r\n.

Share on Facebook
May 8 / kornelius

FileIOPermission failed for assembly with FullTrust Permission Set

After setting fulltrust for an .net assembly to enable it to run from a network share I ran into a figured got into an exception saying:

Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Source: mscorlib
StackTrace: at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.IO.DirectoryInfo..ctor(String path)

After trying a while I figured out, that this occures if the code group points to a single assembly. As soon as I pointed it to the whole directory it worked.
This might be because other assemblies are used by the main application.

The call I used to set the code group is
caspol.exe -machine -addgroup LocalIntranet_Zone -url "z:\pathtofile\*" FullTrust -name "mynewcodegroup"

Share on Facebook
Apr 5 / kornelius

Cleaning the asyncoperationbase table in MSCRM 4 pt 3

Microsoft now cares about the problem I posted here:

http://www.kornelius.org/index.php/blog/2-news/37-cleaning-the-asyncoperationbase-table-in-microsoft-crm-4-part-2

Just execute the following KB articles in the order posted:

http://support.microsoft.com/kb/961768/EN-US/

http://support.microsoft.com/kb/957871/EN-US/

http://support.microsoft.com/kb/968755/EN-US/

http://support.microsoft.com/kb/968520/EN-US/

Please note the last action can take quite a while. I changed the row

Select @DeleteRowCount = 2000

to a much higher value

Doing so all workflows etc. are delete right after their (successful) completion. The only thing remaining are matchcode updates. I’ll think about handling them with bulk deletion.

Share on Facebook