Kay Smoljak wrote: > Been through that - the dbo role has the user in question listed first > on both servers. > I'm really stuck!
if you can only access that table using a user name as a qualifier then that user's not the DBO. can you query the unqualified table using query analyzer using that user/password? if you add the user/password to cfquery does it work? dumb questions: any chance you're not looking at same db/server? what driver? JDBC? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232846 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
