Red Gate forums :: View topic - Access to the path 'c:/somepath/dbo.mysp.sql' is denied
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Access to the path 'c:/somepath/dbo.mysp.sql' is denied

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Skylink



Joined: 07 Apr 2014
Posts: 1

PostPosted: Mon Apr 07, 2014 9:43 pm    Post subject: Access to the path 'c:/somepath/dbo.mysp.sql' is denied Reply with quote

Hi,

My team has just started using SSC3 (dedicated model) and we're seeing some troubles commiting changes to Perforce.

Commit goes through all the steps, checks off 'updating file set' as successful then fails 'sending files to source control (see details above). The details above are:

Access to the path 'c:/somepath/dbo.mysp.sql' is denied

Linking to the database and Getting Latest seem to work fine. Commit works the first time after linking the db but fails sometime after that.

We have checked the files. They are always there with no strange admin/etc permissions on them. They are readonly (perforce does that).

Any help you could provide would be greatly appreciated. We're a bit behind and this tool shows alot of promise if we can get around this checkin problem.

Thanks!!!
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Fri May 02, 2014 5:37 pm    Post subject: Reply with quote

Hmm. We've had a report of this before (this forum thread: http://www.red-gate.com/MessageBoard/viewtopic.php?t=14228 ) but it doesn't look like we ever got to the bottom of it.

If SQL Source Control is failing at the 'sending files to source control' step, then the error returned is an error directly from Perforce, so I'm not really sure what could be causing that. There's a few things like this on their forum that seem like they might be relevant: http://forums.perforce.com/index.php?/topic/1193-perforce-not-modifying-file-read-only-attribute/

My best guess is that there's something going askew in how Perforce is dealing with checked out files, but that's as far as I can really speculate - I'm afraid I don't have a huge amount of experience working with Perforce. I assume you're using the config file provided to work with Perforce - it might be worth trying the 'Working folder' option and manually checking in changes with the Perforce client to see if that works any better. Here's our documentation about how using the Working folder option works: http://documentation.red-gate.com/display/SOC3/Using+working+folders

Hope that helps a bit!
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group