Friday, November 25, 2011

How to resolve: "Unrecognized attribute ‘targetFramework’. Note that attribute names are case-sensitive"


I was getting the error "Unrecognized attribute ‘targetFramework’. Note that attribute names are case-sensitive" on an ASP .NET 4.0 website. This was caused by the application pool targeting the wrong .net framework, change the application pool to the correct .net framework and the error will be resolved.

Error
image
Solution
image

Thursday, November 24, 2011

Pack and minimize your JavaScript code size


In pursue for my JavaScript code performance and some questions on jQuery mailing list I looked for and eventually came across some of the JavaScript code packers. Here is a list of custom JavaScript code compressors available for free.
  1. YUI Compressor (from Yahoo)
  2. JSMin (by Douglas Crockford)
  3. ShrinkSafe  (from Dojo library)
  4. Packer (by Dean Edwards)
According to general opinion of developers on the net (and jQuery official site) you should use Yahoo's YUI Compressor to compress your jQuery and JavaScript code.

Wednesday, November 23, 2011

Fix SQL Server 2008 Express Full Text Index Management Missing



If you installed the SQL server 2008 express and you are missing the ability to manage full text indexes inside SQL server 2008 management studio. I.e. you are missing the storage folder inside management studio.
First make sure you installed SQL Server 2008 Express with Advanced Services (the version without advanced services does not support free text search functionality).
Second Try to Install SQL Server 2008 Express Edition Service Pack 1. Besides fixing some bugs it added the ability to manage full text indexes on my machine.

Saving changes is not permitted. The changes you made require following tables to be dropped and re-created – SQL SERVER 2008


ay while working in SQL Server 2008, I encounter an interesting problem which does not allow me to change design of any table in particular database. Each time when I try to change table columns or resize the I receive following message,
Saving changes is not permitted. The changes you made require following tables to be dropped and re-created. You have either made changes to a table that can’t be recreated or enabled the option prevent saving changes that require the table to be re-created. 
blog1
Fig – (1) SQL Server 2008 – Saving changes is not permitted
         You will receive this message when you restore database created on other server. SQL Server 2008 by default prevent changes for database which are created on another server by enabling “Prevent saving changes that require table re-creation” from Tools – Options.
blog2
Fig – (2) Solution – SQL Server 2008 – Saving changes is not permitted
    To solve this go to Tools – Options and uncheck “Prevent saving changes that require table re-creation” option.

Friday, November 18, 2011

SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string ‘


User can escape single quote using two single quotes (NOT double quote).
Following T-SQL Script will give error
USE AdventureWorks
GO
SELECT *
FROM Person.Address
WHERE City = ‘Villeneuve-d’Ascq’
GO
Resultset:
Error: 105 Unclosed quotation mark after the character string ‘
To fix the error mentioned above, escape single quotes with two single quotes as displayed in following example.
USE AdventureWorks
GO
SELECT *FROM Person.AddressWHERE City 'Villeneuve-d''Ascq'GO

Free IE Tester (Multi Version IE Simulator) For Web Designer


If you are a web designer, I think you will need this web browser tool/IE Tester. This web browser will help you to render your website on various version of IE in one machine. It is useful for web designer that need to view their work on various version of IE browser. This tool can render as IE8, IE7 IE 6 and IE5.5, and it works on Vista and XP.
This tool very useful, so we don’t need to use more than one computer to debug your website in various version of IE browser that usually a nightmare for web designer.

Preview of IE Tester :
Free IE Tester - Multi IE Debugger
http://www.my-debugbar.com/wiki/IETester/HomePage

Saturday, November 12, 2011

Why Do I Receive a "The page cannot be found" Error With ASP On Windows Server 2003?


When you have installed ASP on Windows Server 2003, you may receive the following 404 - Page Not Found error:

The page cannot be found

The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
Please try the following:
  • Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.
  • If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.
  • Click the Back button to try another link.

HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)


Technical Information (for support personnel)
  • Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404.
  • Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site SetupCommon Administrative Tasks, and About Custom Error Messages.

This error is only thrown with dynamic ASP pages; static HTML files, graphics etc are served just fine. 

This error is caused by the fact that IIS 6 disallows the ASP Web Service Extension. To fix this, follow these steps:
  1. Open up the Internet Information Services (IIS) Manager (which you find under Administrative Tools)
  2. Expand your server
  3. Select Web Service Extensions
  4. In the right hand pane, click ASP (or a later version number) and then click the Allow button.
From now on, IIS is allowed to serve ASP pages, and won't throw 404 errors for every page in your site.

Why Do I Receive a "The page cannot be found" Error With ASP.NET On Windows Server 2003?


When you have installed ASP.NET on Windows Server 2003, you may receive the following 404 - Page Not Found error:

The page cannot be found

The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
Please try the following:
  • Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.
  • If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.
  • Click the Back button to try another link.

HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)


Technical Information (for support personnel)
  • Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404.
  • Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site SetupCommon Administrative Tasks, and About Custom Error Messages.

This error is only thrown with dynamic ASPX pages; static HTML files, graphics etc are served just fine. 

This error is caused by the fact that IIS 6 disallows the ASP.NET 2.0 Web Service Extension. To fix this, follow these steps:
  1. Open up the Internet Information Services (IIS) Manager (which you find under Administrative Tools)
  2. Expand your server
  3. Select Web Service Extensions
  4. In the right hand pane, click ASP.NET v2.0.50727 (or a later version number) and then click the Allow button.
From now on, IIS is allowed to serve ASP.NET 2.0 pages, and won't throw 404 errors for every page in your site.

Wednesday, November 2, 2011

Disable Startup Programs In Windows XP, Vista to free-up system resources

This article gives instructions on disabling start up programs in Windows XP & Vista to free up system resources and make pc faster.
Startup programs in Windows XP VistaInstalling many different programs can eventually slow down your computer. Over time you may notice that your computer is very slow at start up. This may be due to the fact that many or some of your programs are configured to start automatically when your computer starts up. And this will definitely slow the start up process as well as consume memory.

Disable Programs at Startup Windows XP

There are many reasons why it's sometimes useful to disable programs at startup in Windows XP. For example if your computer is freezing up or you want to identify potential issues with system performance, then it's sometimes helpful to turn off programs at startup as a part of the troubleshooting process. Other reasons for turning off programs could be to free up memory to increase system performance, or to simply eliminate potential conflicts that might arise. There are other reasons not listed here.

How Can I Turn off These Programs From Running At Startup?

There are many different ways to prevent programs from running at startup. Two common methods are listed below.

Method 1: Configuring Windows Startup Folders for Windows 95/98/Me/XP/Vista

You may find a number of program shortcuts if you go to (Start ¨C> Programs ¨C> Startup) or (Start ¨C> All Programs ¨C> Startup). Programs of these shortcuts will run at startup. Just delete the shortcuts that you don't want to run at startup, based on your OS listed below:
  • Win9x/98/Me - C:\Windows\Start Menu\Programs\StartUp
  • WinNT/2K - C:\Winnt\Profiles\All Users\Start Menu\Programs\StartUp
  • WinXP/Vista - C:\Documents and Settings\All Users\Start Menu\Programs\Startup

Method 2: Using System Configuration Utility (MSCONFIG)
  1. Use the System Configuration Utility to safely turn off programs that start-up through the Windows Registry. Access this utility by going to the Start-->Run
    Run window when starting MSconfig
  2. Type msconfig and press Enter.
  3. Under the Startup tab there is a list of all the programs that start in the Windows Registry. By unchecking many of the programs you can speed up the launch time of Windows.
  4. It is recommended that you keep the lines that say ScanRegistry and SystemTray.
    System Configuration Utility window


Some of the startup programs are important. If you are not sure, you better leave the item untouched, but you are free to experiment (you can always turn them on again). If you find the above instructions are too complicated, you should either ask an tech expert or download a professional software like PC Washer to manage startup options.

Finally it is also suggested to disable unnecessary Windows services from startup to free-up more resources to make your PC faster.
 Tips: Use WinSysClean TM for automatical optimization. Fix, clean, and speed up your computer without adding hardware. Download a free trial version of WinSysClean 2009 to get the best performance of your PC.