Overview of 64bit SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Ram Kishore » Overview of 64bit SQL

Overview of 64bit SQL

Rate Topic

Display Mode

Topic Options

Author

Message

ramki120

Posted Monday, October 27, 2003 12:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 23, 2007 7:11 PM
Points: 3, Visits: 1

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

Post #17657

cppwiz

Posted Friday, October 31, 2003 7:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:05 AM
Points: 163, Visits: 356

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

Post #84893

moh

Posted Thursday, June 29, 2006 10:57 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:35 AM
Points: 20, Visits: 419

Excellent newsletter

Post #291296

MudLuck

Posted Wednesday, February 11, 2009 6:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 5:32 PM
Points: 125, Visits: 453

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...

Post #654725

« Prev Topic | Next Topic »

Permissions