xbase ODBC with DBF. Write permission on Folder?

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Posts: 2
Joined: Tue 07 Jan 2020 07:45

xbase ODBC with DBF. Write permission on Folder?

Post by rhug » Tue 07 Jan 2020 08:12

Hi all
I'm using the trial version of the xBASE ODBC driver to read data from VisualFoxPro (.dbf). I only need to read data!
I have a working test setup on a Windows 2012 server, 64-bit where I use an O365 64-bit MS Access database with linked tables (dbf-files). Same works for pass-through queries. Everything is on that server. Same setup works when the data files are on a network share with full permission on the folder where the data files are stored.

As soon as I try to access data on a folder where I only have read/execute rights, it doesn't work anymore and it looks like it requires write access. Granting write access to that folder confirmed the assumption. However, I would like to know if there is really write permission required or can this be prevented!?

Thanks René

Devart Team
Posts: 384
Joined: Tue 03 Oct 2017 11:00

Re: xbase ODBC with DBF. Write permission on Folder?

Post by Stellar » Tue 14 Jan 2020 11:14

We've changed the behavior of our driver in the Unsafe mode. To read data from a DBF file, it's now opened in the read-only mode, without write permissions. These changes will be included in the next build of our driver.

Post Reply