Wednesday, September 22, 2010

Block search engines


What are we cooking today?
How to block Search Engines from indexing site.


Recipe
  1. Add a robot.txt file with instructions to prevent all robots from indexing the page
    User-agent: * Disallow: /
  2. I added a tag in the links to prevent from indexing too.
    Sample http://www.mylink.com rel="nofollow">My Link
  3. I added a metatag :  

    Other details

    To exclude all robots from the entire server
    User-agent: * Disallow: /
    To allow all robots complete access
    User-agent: * Disallow:
    Or create an empty “/robots.txt” file.
    To exclude all robots from part of the server
    User-agent: * Disallow: /cgi-bin/ Disallow: /tmp/ Disallow: /private/
    To exclude a single robot
    User-agent: BadBot Disallow: /
    To allow a single robot
    User-agent: WebCrawler Disallow: User-agent: * Disallow: /
    More on robots --> http://www.robotstxt.org/


Friday, September 10, 2010

MS Access connection on 64 bit

What are we cooking today?
Connecting to an Access Database that was working OK on a 32 bit OS but was moved to a 64bit OS like Windows Server 2008.

If you use Microsoft.Jet.OLEDB.4.0 when your server has 64 bit, it just don't work.

Recipe

Go to 



http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en




download and install the Microsoft access database engine .exe and change the connection string that fits your case.


The one that worked for me was:




"...If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to
 “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file” ..."