Thanks Tom and Brendan. All is working now! Yippee. I learnt a good lesson from this: Always double check something if you have not done it yourself and don't know the person that did!
I created a new blank db, did an import and refreshed and it worked like a charm!! I'm keen for the community and the Daemon dudes to see this site as it is fairly feature packed. The site is/will be community based, gathering in all aspects of the automotive industry. There are plenty of custom types (probably about 10 or 15) including things like businesses, clubs, members, news, events, feature articles, sponsors, competitions, advertisements etc etc. We are spending the next week or so adding content then we will send u dudes thru the url - if you are interested. Also, I'm pushing to get to MXDU next year and if I get there I would love to chatch up with one or two of you to chat farcry ;) CYA'S Ben -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Cornilliac Sent: Thursday, December 11, 2003 9:07 AM To: FarCry Developers Subject: [farcry-dev] Re: Problems moving from dev to prod. Short of checking your Datasource settings I'd get on the horn with your host and tell them the SQL Server security is wrong. I don't see a Farcry problem here and a Db reinstall probably won't work given the security issues. Good luck! ~tom >[Macromedia][SQLServer JDBC Driver][SQLServer]SELECT >permission denied on object 'config', database 'injektd', owner 'dbo'. > ><cfquery name="q" datasource="#arguments.dsn#"> >42 : SELECT configName FROM #application.dbowner#config</cfquery> > >As you can see. Looks like a sql server permissions problem. >Even tho they ensure that dbo os the owner and that is what is >set in the var application.dbowner > --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
