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

Answer 5

Hi,

I have the same issue.

I need to connect to AS2000 from Excel.

Actually, on a Windows 10 x64 machine with Excel 32 bit, this doesn't work.

Does I need a 32 bit O.S.?

Thanks

Answer 6

It doesn't matter what architecture the OS is in this regard. What matters is the architecture of the client. So if you are using a 32 bit client (Excel in this case) on a 32 bit or 64 bit OS you need a 32 bit driver. Essentially a 32 bit application can only see 32 bit drivers and 64 bit applications can only see 64 bit drivers.

---

http://bi-logger.blogspot.com/

Answer 7

 Essentially a 32 bit application can only see 32 bit drivers and 64 bit applications can only see 64 bit drivers

---

Ok, but this driver is included with Office 32 bit?

And why it works with Excel 32 bit installed on a x86 O.S. and doesn't works if Excel 32 bit is installed on a x64 O.S.?

Thanks

Answer 8

It depends which version of office you have installed. Office 2003 and Office XP used to have it as part of the install. But Office 2013 definitely no longer comes with the SSAS 2000 provider and I don't recall seeing after installing Office 2010 either.

You have to download it and install it yourself if you have a recent version of Office.

---

http://darren.gosbell.com - please mark correct answers

Answer 9

You have to download it and install it yourself if you have a recent version of Office.

---

Where Can I find this driver?

Answer 10

I think it's actually part of the SQL Server 2000 install or it's included with the latest service pack that you installed. There is a file called PTSFull.exe (PTS stands for Pivot Table Services) that I think has all the client data access components.

---

http://darren.gosbell.com - please mark correct answers

Answer 11

I think it's actually part of the SQL Server 2000 install or it's included with the latest service pack that you installed. There is a file called PTSFull.exe (PTS stands for Pivot Table Services) that I think has all the client data access components.

---

http://darren.gosbell.com - please mark correct answers

Thanks a lot.

You saved me a lot of time!

The installer is in the SQL Server 2000 CD, under \\msolap\install\PTS