ODBC Driver for SQLite

Sandboxed Applications on macOS - ODBC Driver for SQLite

Sandboxed Apps on macOS

Sandboxed applications don’t have permission to access iODBC Driver Manager on macOS. This is caused by the System Integrity Protection (SIP) technology on macOS which protects your files and folders from potentially malicious software by locking the application. When accessing a data source from an application like Excel through the ODBC driver for SQLite, you may get an error message saying that the driver is unable to create a file.

Note that all third-party applications distributed through the Mac App Store are sandboxed.
If you access SQLite from Excel, place the database files in the /Users/<username>/Library/Containers/com.microsoft.Excel/Data/Documents/ directory.

Disabling System Integration Protection (SIP) on macOS

To resolve the issue, you should turn off SIP on your computer:

  1. Restart your computer in Recovery mode (hold down Command + R until you see the Apple logo).
  2. Select Utilities > Terminal.
  3. In the Terminal window, enter csrutil disable.
  4. Disable SIP on macOS

  5. Restart your computer.
  6. Enter csrutil status to check the status of SIP.

  7. Check SIP status on macOS

Enable SIP after you finish working with an ODBC data source. To turn on SIP, enter csrutil enable and restart your computer.

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