ODBC Driver for SQLite

Sandboxed Applications on macOS - ODBC Driver for SQLite

Sandboxed Apps on macOS

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.

Disabling System Integration Protection (SIP) on macOS

To give your application the necessary permission and get rid of the error message, you need to turn off SIP on your macOS.

  1. Turn off your Mac.
  2. Reboot your Mac into Recovery Mode by restarting your computer and holding down Command + R until you see the Apple logo on your screen.
  3. Click Utilities > Terminal.
  4. In the Terminal window, type in csrutil disable and press Enter.
  5. Restart your Mac by entering reboot in the Terminal.

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".

Recovery Mode on macOS

Disable SIP on macOS

Reboot macOS from Terminal

Check SIP status on macOS

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.

© 2015-2021 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback