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 ««12

installing 32-bit SQL Server 2008 on 64-bit Vista Ultimate Expand / Collapse
Author
Message
Posted Tuesday, June 9, 2009 5:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 11:21 PM
Points: 40, Visits: 2,474
Yes, one would think there should be a better solution however, Microsoft have not released 64-bit versions of ACE and their suggestion is to use SSIS when accessing external data. Which is not appropirate for my app, in the mean time the 32-bit / 64-bit solution... while clunky works fine.
Post #731340
Posted Wednesday, June 10, 2009 7:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 9:29 AM
Points: 10, Visits: 229
I just had a case open with them on this issue and their solution was to install a 32 bit instance of SQL and via linked server call a proc to run the openrowset.
I guess I should know better, but I was shocked M.S. pulled this one.

After I questioned the suport staff a bit they researched and said that their would be 64 bit text/excel drivers at some point. The next version of Office is supposed to come in both 32 and 64 bit flavors, so I guess we should get 64 bit drivers as it approaches or at least when it is released.


FisherDad
Post #732236
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse