Monthly Archives: March 2012

Google Desktop Search has been discontinued

I was looking to install Google Desktop Search on my Windows 7 64 bit system. I could not see any relevant link from google which wasinteresting because it is google’s own product. The page that appears at the top of search Inside Google Desktop is actually blogspot site (owned by google also). It does not specifically say, google destop search has been discontinued. But if you read it carefully, towards the end of the first paragraph, it says

As of September 14 [2011], Google Desktop will no longer be available for download, and existing installations will not be updated to include new features or fixes.

Thanks again to all of our users. It’s been a fun journey.

If you visit the previous home page of google desktop, you will see a glimps of the image and then redirected to the above site.

That actually says Google Desktop Search has been discontinued. Although the older version of google desktop are still available from CNET and is supported by Google.

Test CPU Speed using JavaScript

Run this code above and see how fast your processor does the math.

Error Locating Server Instance Specified

Connecting to the server through a third party software/interface can give you the following error.

[SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

This basically means, the SQL Server location setting is wrong. This can be resolved in two ways

  1. Either specify the Server instance (for Named Server

    Example: SERVER = MYPCNAME\SQLEXPRESS

    Example: SERVER = MYPCNAME\SQLEXPRESSTEST

  2. Specify the Computer Name only (for unnamed Server)

    Example: SERVER = MYPCNAME

and

Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.

Upgrade SQL Server 2005 instance to 2008

You have SQL Server 2005 running and your needs have changed. Your new product needs SQL Server 2008. You have two options

1. Create a new instance of SQL Server 2008

2. Upgrade your existing SQL 2005 instance to 2008

If you have a number of databases running, it would be prudent to just upgrade the instance. If SQL 2008 is required, SQL 2005 will not work. But SQL 2005 instance does work with SQL 2008 SQL Server Management Studio. By the way SQL Server 2008 is way better than 2005.

So we are now going to upgrade our SQL Server 2005 Instance. Here are the steps you need to follow.

Step 1. Navigate to Server 2008 R2 Installation Center

Go to start ->All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Installation Center

Virual Hosts in Apache XAMPP in Windows

In previous version of Apache one httpd.conf file was maintained for all setting of the Apache webserver, including Virtual hosts. In later version, this apprach has been changed. It has been made more modular so that httpd.conf file contains a link to Include “conf/extra/httpd-vhosts.conf”.
The virtual host file contains all virtual hosts. By default no virtual hosts are provided. Templates are available though which can be modifed according to the needs. Some tweak of windows host file is needed as well.

Using this appraoch,  you can host a website anywhere on the hard disk, not necessarily only in htdocs folder

Steps

1.  Start with Window host file. Copy


C:\WINDOWS\system32\drivers\etc\hosts

in Window explorer. This file does not has an extension. It will ask you a choice which program to use. Select notepad.

2. Edit the file. Add this entry

127.0.0.1 localhost
127.0.0.1 mytestsite <----- I have added this entry

3. No Go to virtual host files maintained by Apached. They are located in this file

C:\xampp\apache\conf\extra\httpd-vhosts.conf

Almost all of this file is commented, make sure you added this two entries in this file. Are you can ucomment the existing one and modify it to these (more desirable)

 

NameVirtualHost *:88 # put this in the beginning of the file

Notice that my test sites is sitting in C:\MyWebsites\Justablog\ folder. Use forward slashes instead of backwards.

4. Create this folder and put a test php file in it such as this. Name it index.php


echo "

I am alive

 

";
?>

5. The virtual hosts are not by default linked in the httpd.conf file. Edit the httpd.conf file and search for this string


Include "conf/extra/httpd-vhosts.conf"

If you can’t find it. Search for a smaller part of the above string. If you find it and there is no # symbol ahead of it, leave it as it is. Otherwise remove the # sign.

5. If you restart your apache server at this point and access the site, you will be given access denied error. To fix that you have to add the permission in httpd.conf file (the one you have already opened). Add this somewhere

somewhere above

entry.

At this point you should be all set.

Make sure all directories that are entered in config file are case sensitive, otherwise it will not work.

Serving websites outside htdocs in XAMPP

Veeras is a great post, how you can serve your website other than htdocs folder in XAMPP. There were a couple of things that were missing which I should document for myself. I will repeat the whole process as well.

Note that everything here is case sensitive. Example is not same as example

Steps

1. Create a root directory in C:\Blog which is outside xampp\htdocs folder. *Note the capital B*
2. Open [this is my xampp root]\apache\conf\httpd.conf in notepad.

3. Search for this line <Directory “C:/xampp/htdocs”> in httpd.conf. Enter the following code above this line (and above the comments that starts with # signs)


# Note: Blog != blog #
Options Indexes FollowSymLinks Includes ExecCGI
AllowOverride All
Order allow,deny
Allow from all

4. Next Search for ScriptAlias /cgi-bin/ "C:/xampp/cgi-bin/" line in the above file. And write this code right below it


Alias /blog/ "C:/Blog/" # Case sensitive!

5. Restart Apache Server in Xampp by going to Start->Apache Friends->XAMPP->XAMPP Control Panel

Now you can type localhost/blog/ and it should take you to the new site.

This is a little bit tricky.
localhost/Blog/ will not work
localhost/blog will not work either but
localhost/blog/ works

So make sure you do every step right. Do not leave any forward slash where it is needed.

Also you may search for part of the strings above to go to the relevent part. With each xampp, thing and shorts change a little bit. This tutorial is current with XAMPP 1.7.7, PHP 5.3.8, year 2012.

Weird Software Bugs

I commented the registeration line for GemBox Spreedsheet in ASP.NET application. The code worked fine. We ran reports for a week. All of a suddent, when I really did not touch the code and I was working on something else, a collegue told me about this error. I immediatly recognized and fixed the issue by uncommenting the reg line. And it worked.


SpreadsheetInfo.SetLicense("EW1M-H15T-JJRK-XXYY");

Why it all of sudden it throw error? I do not know.

Groupon Goods Scam

My wife sent me a link for a Groupon Goods Deal for an iPad Cover which was selling for $19 (actual value $100) that is 81% off. I had bought from Groupon Goods before and I knew Groupon Goods has one big competitor that is Amazon.com. So I quickly checked the price for same item on Amazon.com and found the same deal at a better price, cheaper than group goods. Looking at Groupong Good, who sold more than 5000 of these, I would have jumped on this deal myself

Groupon Goods Deal

Groupon Goods vs Amazon.com

Groupon Goods Deal for iPad cover

Amazon.com Deal

 

winner

Amazon.com

Notice that Groupon Goods has sold 5,000 of them in just a couple of days. Amazon could have never beat this ( I am assuming). If you knew there is better deal on Amazon and probably (most likely) quicker shipment + you get to view the revews, Amazon price is a lot better. Of course it is not touted as deal. It is just a regular price.

 

Moral of the Story: When buying a deal from Group goods,  check prices at Amazon.com first!

This article was published with good intentions of saving you money rather than saying any bad things about Groupon Goods

Using XPS files instead of Adobe Reader

There are certain cases where XPS file can be quite handy to use instead of PDF.  I love PDF and I think it is a great tool, but there is one case where I had to restor to XPS file, that is filling out a fillable PDF file that you cannot save!

If you happen to be in this position to fill out a fillable PDF file but you can’t save it. XPS is your help. This is what you should do to save you file.

Fill your PDF file and print it (dont worry if you dont have a pinter). Select the XPS Writer in the printing device (if it is not already selected) and print. It will ask you where to store the file and by what name. Give it location and name and you are all set.

Now you can open the contents of the file using XPS Viewer. This should be installed on a latest machine but if not you can download it from Microsoft XPS Viewer