This goes beyond my understanding of SQL Server (2000, Standard Edition, SP3, running on windows 2003 with CFMX 7 and FarCry 3 if that matters at all).
I have a dev box set up which is as close to identical to my client's server as I can make it. On both servers, the FarCry database is set up the dbo user owning all tables. The DSN set up in the CF Administrator uses that same database user. On my dev box, the following works fine: <cfquery datasource="whatever" name="test"> SELECT * FROM sometable </cfquery> On the live box, I have to add the user name to the table or I get an error that the table doesn't exist: <cfquery datasource="whatever" name="test"> SELECT * FROM [db_user].sometable </cfquery> I can't find anything different between them, and it's causing trouble with FarCry as some but not all queries reference the db user as well as the table name. As far as I can tell this started happening some time in the last couple of weeks but I don't know triggered it and the client has not been forthcoming. Any pointers greatly appreciated! -- Kay Smoljak http://kay.zombiecoder.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232835 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
