Article ID: 296929 - View products that this article applies to.
This article was previously published under Q296929
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11428 (Plato7.x)
When you attempt to create an ad hoc data mining model, with the Mining Execution Location set to server (3), a message similar to one of the following messages appears:
-2147467259 The operation has failed because of an error in the COM component (Microsoft(r) OLE DB Provider for Data Mining Services) The model 'Test17_20' does not exist
-2147467259 The operation has failed because of an error in the COM component (Microsoft(r) OLE DB Provider for Data Mining Services) No such interface supported
If the Mining Execution Location property of the connection is set to the server, statements are sent to the server without pre-parsing and checking the type of statement.
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.
Only SELECT statements may be executed remotely. Data Definition Language commands cannot be executed remotely. Commands that use the Data Definition Language, executed remotely, result in the following error message:
-2147467259 : The operation has failed because of an error in the COM component (Microsoft(r) OLE DB Provider for Data Mining Services) Only SELECT statements can be executed remotely on the Analysis Server (use DSO for model creation/maintenance). Check Mining Execution Location property.
Steps to Reproduce Behavior
Article ID: 296929 - Last Review: October 23, 2013 - Revision: 1.2