Thursday, April 22, 2010

VS Dark Themes

I am a big fan of dark themes for Visual Studio and came across the following article by Prabir that has dark themes for VS and others (such as Notepad++):

http://blog.prabir.me/post/My-Dark-Visual-Studio-Theme-Update.aspx

Wednesday, April 21, 2010

OraAspNetConString Missing Connection String Config Error

After the latest Oracle Client was installed on a fresh Windows 2008 R2 Server, any .NET applications using role or membership services would fail with an error about a missing connection string in the machine.config. The Event Log contained the following detail:

Exception information:
Exception type: ConfigurationErrorsException
Exception message: The connection name 'OraAspNetConString' was not found in the applications configuration or the connection string is empty. (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 178)

After doing some digging and comparing with some of our other servers that have earlier versions of the Oracle Client tools, I discovered that the Oracle tools inject several providers and a blank connection string into the machine.config file, and thus when the .NET framework attempts to spin up the providers, these will fail.

Prior to the install, the system.web node contained the following:

image

After the Oracle Client tools install, the system.web node had been modified to include the following Oracle providers:

image

When Oracle Client is installed, notice that it adds 6 different providers into the machine.config and adds a blank connection string with a key of “OraAspNetConString”. You can either a) set the connection string to an appropriate value, or, b) remove the providers and connection string. I removed all 6 of the entries (don’t forget the Framework64 machine.config location too) and this resolved the issue.

Creating TFS 2008 Build Server

The base install used for setting up a TFS 2008 Build server was Windows 2008 R2 Standard.

  • Install Visual Studio 2008 Developer Edition, custom install, with only the Visual Web Developer and Team System Developer tools

image

  • Install TFS 2008 Team Explorer
  • Install Visual Studio 2008 Tester Edition, custom install, with only the Team System Tester Tools.

image

  • Install VS 2008 SP1.
  • Install the Web Deployment Setup.
  • Install VS 2008 DB Pro GDR Update.
  • Install Team Build.
  • Install TFS SP1.

For .NET 4.0 Builds, I also installed:

  • .NET 4.0 Framework
  • Visual Studio 2010 Ultimate with the Web Development tools.

image