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' Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/28/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > > I assume SQL Server's "Invalid object name" error is > > typically a result of a > > missing table or mistyped table name. But I'm seeing it > > at a rather odd > > time. > > > When I run a certain query as part of a CFC function, I > > receive the error > > "Invalid object name 'dbo.tecSOLine'". But if I pull the > > offending query > > out of the CFC and run it independently, it works as > > expected. CF seems to > > know the table exists, otherwise it wouldn't work in any > > situation, which > > leaves me puzzled. > > > Are there other common causes of "invalid object name" > > errors that any of > > you have run across? > > I've seen it throw that error on a view that contains reference to a > deleted table, but that doesn't sound like what you're experiencing. > > > s. isaac dealey 434.293.6201 > new epoch : isn't it time for a change? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236264 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
