Red Gate forums :: View topic - Filename length using windows xp and windows 7
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

Filename length using windows xp and windows 7

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



Joined: 03 Dec 2013
Posts: 1

PostPosted: Tue Dec 03, 2013 3:02 pm    Post subject: Filename length using windows xp and windows 7 Reply with quote

We are looking at using your product for source control using git.

I have linked a database to a git working folder, and committed the objects on a Windows 7 machine with SSMS 2008 R2. Some of the unit test sprocs have quite long verbose names, with the longest path being 186 chars (filename is 134). All of these were committed fine. We use local dev VM's running Windows XP SP3 (low footprint) with SQL Server 2008 R2 Express Advanced. I installed source control 3.9 on here too, and linked the database to a clone of the repository. When I try and get the latest I get the following error message:
The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

The longest path for the VM is shorter at 175 chars, way below the limits in the error message.

Having done some investigation, i can use any path length on the XP VM as long as the filename part does not exceed 114 characters. Is this a know issue when using the product with Windows XP?

Thanks
Niall
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Thu Dec 05, 2013 8:27 pm    Post subject: Reply with quote

I suspect you are getting different results in XP vs. 7 because of the difference in the location of where the two operating systems store local app data.
XP: \Documents and Settings\$USER$\Local Settings
7: \Users\$USER$\AppData\Local
http://social.technet.microsoft.com/wiki/contents/articles/6083.windows-xp-folders-and-locations-vs-windows-7-and-vista.aspx

This would explain why the specified path, file name, or both are too long in XP and not 7 because the XP path will be slightly longer than that of 7.
For the error "The specified path, file name, or both are too long".
We recommend you relocate your working base folder
http://documentation.red-gate.com/display/SOC3/The+specified+path%2C+file+name%2C+or+both+are+too+long
Note: The working base folder is different from the working folder.
http://documentation.red-gate.com/display/SOC3/Changing+the+location+of+the+working+base
_________________
Manfred Castro
Product Support
Red Gate Software
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