Re: Error linked server query after installing SP4 on SQL 2000
- From: "Warren Brunk" <wbrunk@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 12 Oct 2006 13:46:55 -0700
Does changing the "AllowInProcess" to something non zero fix this problem?
http://msdn2.microsoft.com/en-us/library/ms190918.aspx
In Object Explorer, right-click the provider name and select Properties. The
following table describes the available provider options...
thanks,
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Nic" <Nic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E4A1CCBC-331D-4C70-B83C-F1AFE5CFAA62@xxxxxxxxxxxxxxxx
Hello
SQL 2000 SP3a run fine with an linked server query like
select * from openquery( linkedOlapServer, .. here is the MDX ...')
After installing SP4 build 2039 this query fails with error:
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'MSOLAP'.
OLE DB error trace [Non-interface error: CoCreate of DSO for MSOLAP
returned 0x80040154].
Appreciate hints from experience on which hot fix do I need to install?
Nic
.
- Prev by Date: Re: identity on / off
- Next by Date: Re: DateDiff
- Previous by thread: RE: SQL error with Backup Exec 10d
- Next by thread: Cannot connect to remote SqlServer 2005
- Index(es):
Relevant Pages
|
