When you open Omnis Studio, test your ODBC connection using the SQL Browser and an ODBC hostname that matches the name of your ODBC DSN. "odbcdam.ini": "ODBCINI=/Users/myUser/Library/ODBC/odbc.ini, ODBCSYSINI=/Library/ODBC/odbc.ini" Locate the "macos" section and the "odbcdam.ini" section and set your environment variables here, e.g. Libary/Application Support/Omnis/Omnis Studio 10.2 29538/studio/config.json To set the required enviroment variables prior to starting Omnis Studio, edit the contents of the config.json file, e.g.
The contents of a given ODBC DSN are driver-specific, although they normally consist of a Driver key plus the required authentication keys, e.g.ĪctualSqlSvr = Actual Technologies SQL Serverĭescription = SQL Server 17 running on SERVER-PC Values of the ODBCSYSINI and ODBCINI environment variables. User data sources normally reside in ~/Library/ODBC/odbc.ini although the actual locations are determined by the System ODBC data sources normally reside in /Library/ODBC/odbc.ini. Minimum macOS Version Licensing the Driver Connecting through a Driver Manager Configuring DSNs Configuring a DSN with the iODBC Administrator Connecting.
This means that it will not be necessary to move any files into the Omnis.app Frameworks folder.Īlternatively, you can download the archive below and place the driver manager with its symbolic link directly into the Omnis Studio.app/Contents/Frameworks folder. The Installer currently available from the website provides a code signed, universal framework and a symbolic link in /usr/local/lib. Whether you are using the x86_64 edition of Omnis Studio or the arm64/Silcon edition, it will require a compatible libiodbc.dylib or a "universal binary" containing both architectures. You can obtain the iODBC driver manager directly from the website or via the link below. If you want to use an ODBC Driver that is compatible with the Unix ODBC Driver Manager (libodbc.dylib), please refer to technote: TNSQ0038. Which rely on the iODBC Driver Manager (libiodbc.dylib). It is relevant for users who want to use: This technote discusses the use of the ODBC DAM in Omnis Studio 10.1 and later running on macOS 11 (Big Sur). Omnis Technical Note TNSQ0038a March 2021 Using the ODBC DAM with macOS 11 and Later