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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
