This code demonstrates access to OSCOMMERCE database objects which are hosted on a mysql server, through the enitity framework and LINQ. Additionaly, the connectionstring is overriden at runtime to seperate developent and production environments. Install the MySql connector for visual studio Add a ADO.NET Entity data object to the solution Use the Wizard to create […]
Author: bobnoordam
Resursively listing a directory tree using a stack object
The class offered below shows an implementation of an efficient way to scan large filesystem trees and returning the content. By not using recursion but controlling the worklist with a stack element a large part of the load on the GC is reduced. Using recursion the collection of created objects by the recusrive calls can’t […]
Enabling Powershell Hyper-V cmdlets on upgraded systems
One of the great things added with Server 2012 (and Windows 8) is full support for Hyper-V in powershell. There is a long list of cmdlets that make managing virtual machines a breeze. (see: this technet link ). If you upgraded a server from Server 2008/2008R2 to Server 2012 you will find the cmdlet’s oddly […]
HYPER-V Back Script, with optional suspend or stop of the virtual machine
With the help of the powershell applets for HYPER-V it has become quite easy to create a reliable backup of your virtual machines without the need for highly expensive backup tools. The script uses the standard export functionality build into HYPER-V, so you can restore one of these backup’s to the actual virtual machine including […]
Failed to generate a user instance of SQL Server due to failure in retrieving the user’s local application data path
When publishing a web application which includes an integrated SQL database you receive the following error: Failed to generate a user instance of SQL Server due to failure in retrieving the user’s local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. Cause: […]
How can I verify that my local COM ports are redirected in an RDP session ?
A: Start a command window and type the following command at the prompt: change port /query The output will look something like this: AUX = \DosDevices\COM1 COM1 = \Device\RdpDrPort\;COM1:15\tsclient\COM1 COM2 = \Device\RdpDrPort\;COM2:15\tsclient\COM2 COM3 = \Device\RdpDrPort\;COM3:15\tsclient\COM3 LPT1 = \Device\RdpDrPort\;LPT1:15\tsclient\LPT1 PRN = \DosDevices\LPT1 From the above, you can see that COM1-3 and LPT1 are redirected. The number […]
Installing a web application from an msi installer fails on Vista / Windows 7 / Windows Server 2008
Starting the installer results in a near immediate message reading: “the installer was interrupted before this application could be installed. You need to restart the installer to try again.” Additionaly, the eventlog shows eventid 11708 with a short error message stating “installation failed” Resolution: You need to install the IIS6 Metabase compatibility component for the […]
Resolving coalation conflicts with temporary tables
When writing long query’s or stored procedures using temporary tables, you may run into an error like: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. The cause of this error is that the tables you are querying against have a different collation then the server default. This causes the […]
Re-activating the create unit test function in Visual Studio 2012
Visual studio 2010 had a quick rightclick context menu to create unit test which has disappeared in VS2012, to move to a more general approach that isnt directly tied in with the MS unit testing system. It is possible however to re-enable the menu function or use a keyboard shortcut. full writeup source: http://serena-yeoh.blogspot.nl/2013/02/visual-studio-2012-create-unit-test.htmlhttp://blogs.msdn.com/b/malaysia/archive/2013/02/20/right-click-create-unit-tests.aspx Your […]
Exporting a HYPER-V Virtual machine to a network share
If you start a HYPER-V virtual machine export to a share, you will be greeted by an permissions error. This happens both with a manual export, and with a scripted backup through powershell using the Export-Vm cmdlet. note: this procedure does not apply to migrations The resolution for this problem is luckily simple. You need […]