No probs: [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 Ben Original Message: >From: Tom Cornilliac <[EMAIL PROTECTED]> >To: "FarCry Developers" <[EMAIL PROTECTED]> >Subject: [farcry-dev] Re: Problems moving from dev to prod. >Date: Wed, 10 Dec 2003 13:39:22 -0800 >Hey Ben, > >Can you post an error message? That would go a long way towards putting a >pin in the problem(s). > >~tom > >>-----Original Message----- >>From: Ben [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, December 10, 2003 1:26 PM >>To: FarCry Developers >>Subject: [farcry-dev] Re: Problems moving from dev to prod. >> >> >>Thanks for that Brendan. >> >>I will look into it. It is very difficult tho when I have VERY >>minimal access to the server. Mostly have to relay information >>from one person to another - frustrating is the word! I know >>if they just let me at the box I can get it working. >> >>I was thinking. Just to ensure that the db is setup correctly >>would it be worth running the setup again to create a blank db >>with all the permissions etc etc setup? Perhaps then deploying >>all the types and then doing an import of the data? >> >>Regards, >> >>Ben Robinson >> >> >> >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf >>Of Brendan Sisson >>Sent: Wednesday, December 10, 2003 10:35 AM >>To: FarCry Developers >>Subject: [farcry-dev] Re: Problems moving from dev to prod. >> >>Ben Robinson wrote: >> > Moved the site code over. >>> Got the tech dudes where it is being hosted to create a blank sql >>server db. >>> Did an import of the tables and data to the blank db (had issues with >>that too but worked in the end). Created all the mappings >>datasources and virtual directories etc etc >> >> >>Make sure you check that all the default values are set in the types >>tables (eg dmHTML, dmNews etc and fields locked and status etc) >> >> >>> Now trying to run the site I get db errors. Mainly to do with >>permissions on the user dbo for the database which is blowing >>the sql queries which is referencing tables like FROM >>dbo.tablename if you get my drift. >> >> >>You set the dbowner in your <appname>/cofig/_serverSpecificVars.cfm: >> >>application.dbowner = "dbo."; >> >>Change this to what ever your tech guys have set you up with but >>remember the . at the end. Then update your application scope by >>appending updateapp=1 to the url. >> >>Hope that helps >> >>-Brendan >>http://farcry.daemon.com.au >> >> >>--- >>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 > >--- >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
