.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

"'xxxxx\Administrator'user does not have permission to access the 'Local' object, or the object

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

Hi,

I am trying to run the DMX query

select [bikebuyer],
predicthistogram([bikebuyer])
from [TK448 Ch 009 Prediction]
natural prediction join
(select 'm' as [gender],
0 as [number of cars owned]) as t

for my  [TK448 Ch 009 Prediction] model but it's throwing me the error "'xxxxx\Administrator'user does not have permission to access the 'Local' object, or the object does not exist" though it has the Admin permission.

The full query what I am trying to achieve is.

--select * from [predictioncluster].cases
select top 1000
t.[lastname],
t.[firstname],
[bike buyer],
predictprobability([bike buyer],1) as dtpredictprobability,
t.gender,
t.numbercarsowned from [predictioncluster]
prediction join
openquery([Local],
'select [lastname],
[firstname],
[gender],
[numbercarsowned]
from [dbo].[prospectivebuyer]') as t
on[gender] = t.[gender] and [number cars owned]
= t.[numbercarsowned]
where [bike buyer] = 1
order by predictprobability([bike buyer],1)desc

but the same error. Also I am getting the error "The end of the input was reached". If any one could help me out with this issue.

Thanks,

CsKoch




View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend