When querying directory access proxy tables, you must be consistent in your use of path name delimiters. It is best to use your platform's native delimiter: on Windows use \ and on Unix use /. Although the server also recognizes / as a delimiter on Windows, remote data access always returns file names using a consistent delimiter; therefore a query with inconsistent delimiters does not return any rows.

 Example

SELECT contents FROM DirAccessProxyTable WHERE filename = 'some/dir\thing';