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
