Page 1 of 1

TC doesn't open folder created by SQL Server's FileTable

Posted: 2019-01-21, 20:18 UTC
by Sektor
When I create FileTable in SQL Server, it creates a folder under database's root folder (under SQL Server's share name). In previous versions of TC all was fine, but in TC 9.21a x64 (admin mode) I can't open root folder. For instance, the root folder is \\Falcon\MSSQLSERVER\FTTest\Documents\, where FTTest is FILESTREAM directory name and Documents is FileTable name. I can't enter FTTest folder. Database's FILESTREAM Non-Transacted Access is set to Full. In File Explorer everything works fine and I can enter that folder and see everything in it.

Re: TC doesn't open folder created by SQL Server's FileTable

Posted: 2019-01-22, 15:35 UTC
by ghisler(Author)
I'm not aware of any changes causing this.
- Which older version could handle it?
- What are the permissions of the folder (Alt+Enter)?

Re: TC doesn't open folder created by SQL Server's FileTable

Posted: 2019-01-22, 19:12 UTC
by Sektor
Which older version could handle it?
Strange enough, but I do remember that it worked it TC. I tested in 9.00a - and it failed to work. Perhaps, it was v.8?
What are the permissions of the folder (Alt+Enter)?
The folder actually doesn't exist in file system - it's managed solely by SQL Server. Here are the properties:
Image: https://i.imgur.com/yMnOktq.png

Re: TC doesn't open folder created by SQL Server's FileTable

Posted: 2019-01-24, 10:57 UTC
by ghisler(Author)
You can find old versions here:
https://www.totalcommander.ch/win/old/
It's easy to try them, just install as update, and when done, reinstall the latest.