this is probably way to obvious but is the datasource the same in the cfc ......
On 3/27/06, Paul <[EMAIL PROTECTED]> wrote: > > Mike, I appreciate your response. I had already experimented with table > ownership, with no luck. > > The error seems to be pretty clear - one would think it is surely related > to > table name or access permissions - but I can run the query successfully > from > a separate CF page and not from within the CFC. In that regard it seems > like the problem may be the data involved, not permissions, since > permissions/table name would be globally rejected... > > Anyway I'm chasing my tail. I think I may have to deconstruct my CFC and > find a new way to accomplish the same end. Maybe in the process I'll find > the bullet I'm overlooking... > > Thanks again for your input, Mike & Isaac. > > -----Original Message----- > From: Mike Kear [mailto:[EMAIL PROTECTED] > Sent: Monday, March 27, 2006 12:30 PM > To: CF-Talk > Subject: Re: Invalid object name > > What if the problem isnt the table name but the owner name? > > I've had similar issues, and replaced SELECT * from dbo.tecSOLine > > with SELECT * from tecSOLine > > IF that works where the other doesnt, then you probably need to either > change your query code, or change the object owner. Look in Books Online > for how to do it for your database, but in SQLServer2000 there's a SP you > use as follows: > > exec sp_changeobjectowner 'dbo.secSQLine', 'otherlogin' > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
