http://bugs.winehq.org/show_bug.cgi?id=20675
Summary: Excel 2007 Analysis Services -- no network activity at all Product: Wine Version: 1.1.32 Platform: PC OS/Version: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: -unknown AssignedTo: wine-bugs@winehq.org ReportedBy: imirkin@alum.mit.edu
I'm running into an issue with the Analysis Services module (aka OLAP) in Excel 2007.
It presents me with a screen that asks for the server name (and asks for auth types), and then proceeds to fail-fast to a generic error:
""" Unable to connect to data source. Reason: Unable to locate database server. Verify that the database server name you entered is correct, or contact the database administrator for help. """
However doing a network trace, no packets ever go out the external interface.
Relevant bits from +relay,trace+reg (note that I added an extra TRACE to RegQueryValueW that prints out the data that it returns):
""" 0009:Call advapi32.RegQueryValueW(80000000,0032d3bc L"MSOLAP\Clsid",0032d3bc,00 32d3b8) ret=326c46e5 trace:reg:RegQueryValueW (0x80000000,L"MSOLAP\Clsid",0x32d3bc,512) trace:reg:NtOpenKey (0x13c,L"MSOLAP\Clsid",f003f,0x32d2f8) trace:reg:NtOpenKey <- 0x28c trace:reg:RegQueryValueExW (0x28c,(null),(nil),(nil),0x32d3bc,0x32d3b8=512) trace:reg:NtQueryValueKey (0x28c,(null),2,0x32d1a0,256) trace:reg:RegQueryValueW L"{176941F9-18E8-47D6-860D-006FF2655608}" 0009:Ret advapi32.RegQueryValueW() retval=00000000 ret=326c46e5 0009:Call KERNEL32.FindResourceA(01560000,00000006,000000d9) ret=326155f6 0009:Ret KERNEL32.FindResourceA() retval=0156dd80 ret=326155f6 0009:Call KERNEL32.LoadResource(01560000,0156dd80) ret=32615606 0009:Ret KERNEL32.LoadResource() retval=0158a6f8 ret=32615606 0009:Call KERNEL32.LockResource(0158a6f8) ret=32615615 0009:Ret KERNEL32.LockResource() retval=0158a6f8 ret=32615615 0009:Call KERNEL32.TlsGetValue(00000007) ret=3260568c 0009:Ret KERNEL32.TlsGetValue() retval=00620000 ret=3260568c 0009:Call KERNEL32.TlsGetValue(00000007) ret=3260568c 0009:Ret KERNEL32.TlsGetValue() retval=00620000 ret=3260568c 0009:Call advapi32.RegOpenKeyExW(80000001,00630024 L"Software\Policies\Microsoft\Office\12.0\Common\Alerts",00000000,0002001f,003240c0) ret=3260556d """
And then it goes on to generate the alert. So for some reason it totally fails and doesn't even try to do anything after looking up the registry key.
FWIW, here are a few entries from system.reg:
""" [Software\Classes\MSOLAP\Clsid] 1237579662 @="{176941F9-18E8-47D6-860D-006FF2655608}"
[Software\Classes\CLSID\{176941F9-18E8-47D6-860D-006FF2655608}] 1237579662 @="MSOLAP"
[Software\Classes\CLSID\{176941F9-18E8-47D6-860D-006FF2655608}\InprocServer32] 1237579662 @="C:\Program Files\Common Files\System\ole db\msolap90.dll" "ThreadingModel"="Both" """
I do not see the string "176941F9-18E8-47D6-860D-006FF2655608" anywhere in the trace logs, except as the return value to RegQueryValueW. (But I don't know a whole lot about Windows, perhaps that's to be expected.)
I'm happy to do more debugging here, so any ideas appreciated. I don't appear to have any DLL overrides.