Connecting to AS2000 from X64 Excel Services – SharePoint

I can’t imagine too many people will have this issue, but just in case you you have a similar environment it’s bad news I’m afraid.  Connections from 64-bit applications to AS2000 aren’t possible as there is no x64 oledb 8.0 AS driver.  If you’re running IA64 then you’re fine as MS built a library for this version (?)

The alternatives? Run SharePoint and IIS in 32-bit mode or, probably better, point out to your boss/customer/IT dept that 2010 subtract 2000 = 10 years and that it really is time to upgrade to the wonders of SQL2008 R2.  The fact they can actually get support for this version might help swing it 😉

Read our other blogs here