Overview of 64bit SQL

  • ramki120

    SSC Rookie

    Points: 25

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rkishore/overviewof64bitsql.asp

  • cppwiz

    Hall of Fame

    Points: 3926

    Shame on you Ram Kishore and the owners of the SQL Server Central web site for allowing this article to be posted !!!

    This article was plagiarized from a white paper written by Chad Brown of IdentityMine, Inc. in March of 2003. The plagiarism is word-for-word, including the registered trademark symbols. How a respected site like sqlservercentral.com could let this huge faux pas get posted on the home page is incredible.

    Plagiarism is not acceptable !!!

    The original white paper can be downloaded here:

    http://www.hp.es/eventos/itanium2factory/pdf/MS/sql_64_bit.doc

  • moh

    SSC-Addicted

    Points: 466

    Excellent newsletter

  • MudLuck

    SSCrazy

    Points: 2271

    Dam copiers....

    My dual post (of my own writing) to help those that might think upgrading to 64 bit is a good idea.

    Ok all the final word on Jet

    The Microsoft OLE DB Provider for Jet and the Microsoft Access ODBC driver are available in 32-bit versions only

    http://support.microsoft.com/kb/957570

    So frankly what this is telling me is if your using the 64 bit version of SQL server than you can not connect to excel files either via a linked server, OPENDATASOURCE, or reporting services. WOW.

    Talk about a chink in the armor I'm stunned. There are articles on the web that show how to run SSIS in 32 bit mode to support Jet or a IIS server and other MS apps in 32 bit mode, but is that really a solution or a step backwards. [Crazy]

    So lesson learned is step back and think about that for a second before you decide to upgrade your server from 32bit to 64bit. You can go out on the web and read the horror stories of people who did, only to break existing code (ouch).

    Peace out...

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply