dbTalk Databases Forums  

Possible error in Data Link dialog

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Possible error in Data Link dialog in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrew Wiles
 
Posts: n/a

Default Possible error in Data Link dialog - 10-11-2005 , 04:44 AM






I have just installed SQL 2005 CTP on a mchine with SQL 2000. As a
consequence both MSOLAP.2 and MSOLAP.3 providers are registered.

If I create a udl file and fire up the Data Link Properties dialog, Select
the MSOLAP.3 provider listed as "Microsoft OLE DB Provider for Analysis
Services 9.0" and connect to the Adventure works sample database all appears
well. A test connection succeeds. However when I exit from the dialog and
then re-open the link I find that the selected provider is "Microsoft OLE DB
Provider for Analysis Services 8.0". Looking into the datalink the registered
provider is MSOLAP.2

This would appear to be a bug?

Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Possible error in Data Link dialog - 10-11-2005 , 06:47 AM







Quote:
This would appear to be a bug?
Hard to say.

There are known issues with msolap.1 and msolap.2, where if you install
certain products on the same in a certain order msolap.1 becomes the
default driver, even though msolap.2 is present. This may be a similar
issue.

Try re-registering msolap90.dll by running this command:
regsvr32 "c:\program files\common files\system\oledb\msolap90.dll"

That should reset msolap.3 as the default provider

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.