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

Reply via email to