On 9/21/06, Jim Wright <[EMAIL PROTECTED]> wrote: > Matt Williams wrote: > > Anyone dealt with this? > > Some SQL Databases are not accessible from CF. The DSN verifies > > correctly, but I can't hit any of the tables. In addition, the > > Dreamweaver RDS doesn't list the tables, but does list some weird > > tables such as dbo.spt_monitor and dbo.spt_values. > > > > This is SQL Server 2000. > > > Are your tables owned by somebody other than dbo, but you are not > connecting as that user? If so, you would need to refer to the tables > as x.tablename, assuming the user you are connecting with has rights to > the tables. >
Thanks Jim, It turned out to be an ownership problem. I can't really explain the exact answer as I'm just being a intermediary here for a non-CF-Talk subscriber. Anyway, this is the second time this week you gave me the right direction on an issue. What a guy! Thanks again, -- Matt Williams "It's the question that drives us." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
