Ole db provider 64 bits for SSAS 2000

Question

I have a computer with excel 2010 64 bits and I can't connect to Analysis Services 2000  but

in other computer with excel 2010 32 bits there is no problem. So the problem is I need the oledb provider for 64 bits for SSAS 2000

is it correct?

Answer 1

It is correct that for a 64 bit process (like Excel 2010 64 bit) you would need a 64 bit provider as the providers are loaded into the process space of the client application. However to the best of my knowledge there is no such provider for AS 2000.  This is 10 year old technology and there was no 64 bit client OS when it was built.

It sounds like you will either need to uninstall Office 64 bit and install the 32 bit edition (you can't have both the 32 and 64 bit editions on one machine, but you can run 32 bit Office on a 64 bit OS) - Or you could upgrade SQL Server :)

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 2

Note that although a 64 bit version of AS2000 was released near the end of AS2000's life, no 64 bit client tools or OLEDB provider was released. Instead, it was expected that all admin and analytics functions would be performed from 32 bit client machines as, like Darren says, there were no 64 bit clients or at least not in any common form as far as AS is concerned.

However, my understanding is that the OLEDB9 (and 10) provider is meant to be backwards compatible (as is also stated by this article: http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.olap/2005-12/msg00160.html ) so have you tried installing the 64 bit versions of the AS2005/8 providers and connecting with that? Otherwise I guess you could try connecting via HTTP which would eliminate the architecture issue but at the expense of using the HTTP protocol, hassle in configuring this, requirement for more hardware/services and it being slower.

Answer 3

Technically the OLEDB9 (and 10) providers are not truely backward compatible with v8 (AS 2000). My understanding is that if the 9/10 provider detects that the server is v8 then it will hand off to the OLEDB8 provider. So you still need the v8 provider installed and working in it's own right.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 4

Darren is correct. You have no choice other than using a 32-bit client if you need to connect to AS 2000. There was a 64-bit version of the OLE DB provider for it, but it was only for IA-64 and not x64 -- so that's not much use either...

 

Thanks,

Akshai

---

-- This posting is provided "AS IS" with no warranties, and confers no rights