Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Overview of 64bit SQL Expand / Collapse
Author
Message
Posted Monday, October 27, 2003 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, October 31, 2003 7:48 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:34 PM
Points: 165, Visits: 386
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
Posted Thursday, June 29, 2006 10:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, November 23, 2014 3:32 PM
Points: 20, Visits: 450
Excellent newsletter
Post #291296
Posted Wednesday, February 11, 2009 6:26 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 6, 2014 11:27 PM
Points: 126, Visits: 505
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 »

Add to briefcase

Permissions Expand / Collapse