Hi Kay, questions: 1. is it an MSSQL DB? 2. have you restored the DB from another MSSQL server? 3. Are you using the same MSSQL server User name and password?
If so, I have seen problems like this a bit, and the only work round I have found is to delete the user from the DB, and re-add them Kay Smoljak wrote: > My apologies to anyone who is on either CF-Talk or farcry-dev (or both > - double apologies to anyone fitting that description) but this > totally has me stumped. > > http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:44728 > > To summarise, the database user that appears to be the dbo (according > to enterprise manager) which is the user in the CF DSN cannot query > unqualified table names on the live server, although the dev server > works fine. > > It's freaky weird and is causing all sorts of db errors in FarCry and > I'm pulling my hair out - and bald chicks are just not attractive :) > Help! Please! > > -- > Kay Smoljak > http://kay.zombiecoder.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
