InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 15:52:16 GMT20http://www.sqlservercentral.com/Forums/Topic17657-139-1.aspxDam 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 JetThe Microsoft OLE DB Provider for Jet and the Microsoft Access ODBC driver are available in 32-bit versions onlyhttp://support.microsoft.com/kb/957570So 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...Wed, 11 Feb 2009 06:26:03 GMTMudLuckhttp://www.sqlservercentral.com/Forums/Topic17657-139-1.aspxExcellent newsletterThu, 29 Jun 2006 10:57:00 GMTmohhttp://www.sqlservercentral.com/Forums/Topic17657-139-1.aspx<b><font size=6>Shame on you Ram Kishore and the owners of the SQL Server Central web site for allowing this article to be posted !!!</font id=size6></b>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:[url]http://www.hp.es/eventos/itanium2factory/pdf/MS/sql_64_bit.doc[/url] Fri, 31 Oct 2003 07:48:00 GMTcppwizhttp://www.sqlservercentral.com/Forums/Topic17657-139-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/rkishore/overviewof64bitsql.asp>http://www.sqlservercentral.com/columnists/rkishore/overviewof64bitsql.asp</A>Mon, 27 Oct 2003 00:00:00 GMTramki120