Sandboxed Applications on macOS - ODBC Driver for SQLite
Sandboxed applications don’t have permission to create or modify files and folders in your system. This is caused by the System Integrity Protection (SIP) technology on macOS that is designed to protect your files and folders from potentially malicious software by locking them.
In the context of ODBC drivers, sandboxed applications don’t have permission to access iODBC Driver Manager on macOS. When retrieving data from a database into an application such as Excel via ODBC Driver for SQLite on macOS, you may get an error message saying that the driver is unable to create a file.
Note that all third-party apps distributed through the Mac App Store are sandboxed.
To give your application the necessary permission and get rid of the error message, you need to turn off SIP on your macOS.
After reboot, your Mac start will SIP disabled and you’ll be able to fetch data through an ODBC driver without any errors. You can check the status of SIP by entering csrutil status in the Terminal. The message should say: "System Integrity Protection status: disabled".
Don’t forget to re-enable SIP when you finish retrieving data into a third-party application from an ODBC source. You can turn on SIP by following the above instructions and typing in csrutil enable at step 4.