Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
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: Wednesday, February 3, 2016 3:57 AM
Points: 40, Visits: 2,481
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


Group: General Forum Members
Last Login: Tuesday, December 22, 2015 7:08 AM
Points: 10, Visits: 248
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.

Post #732236
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse