Distributed Queries not working for 32 Bit Office 2010 under 64 Bit OS by smetah

Active

Type:	Bug
ID:	777057
Opened:	1/21/2013 7:06:44 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Hi,

The Distributed Queries is not working for 32 Bit Office 2010 under 64 Bit OS. Detailed configuration is:

1. WIndows 7 (64 bit, sure)
2. Microsoft Office 2010(32 Bit, sure)
3. SQL Server 2008 R2 (64 Bit, not sure, how to confirm?)

Detailed trial attempts are logged in
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/6396618e-9e61-46a7-8502-2f69595bdbfa/

Details (expand)

English

SQL Server 2008 R2

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows 7 Professional

US English

Detailed trial attempts are logged in
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/6396618e-9e61-46a7-8502-2f69595bdbfa/

Msg 7308, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

Distributed Queries successful.

X64

0 attachments

Posted by Microsoft on 2/12/2013 at 12:32 PM

Hello,

Thank you for filling this issue. We will investigate this for a future release.

Thanks,
The Analysis Services Team

Posted by Samartha Koharwal on 2/8/2013 at 5:55 AM

hi,
when you install SQL the setup tells you about the 32 or 64 bit.. or you may also check it from the registry editor.

Microsoft