![]() ![]() This will either open the odbc.ini file that already exists in the corresponding directory or create a new file if you are creating the first DSN for the driver. To create a DSN, open Terminal and run the command sudo vi /Library/ODBC/odbc.ini for a system DSN or sudo vi ~/.odbc.ini for a user DSN. For this article, vi is used to edit odbc.ini. You can configure the odbc.ini file using vi or a similar text editor, such as nano. Creating a DSN by Adding Connection Information to the odbc.ini File The odbc.ini file and parameters for a sample system DSN were created during the driver installation, so you can create a new system DSN or specify connection information in the existing DSN. If this is the first time that you are creating a user DSN, the iODBC manager creates the odbc.ini file in the home directory. Double-click on the Value field and specify the value for the parameter. ![]() Double-click on the Keyword field and specify the parameter name.Click on the plus sign to create a Keyword/Value pair.Specify connection string parameters and their values:.Specify a name for the DSN and, optionally, a description.Select the driver (e.g, Devart ODBC Driver for Oracle), then click on OK.Run iODBC Administrator64 from Applications > iODBC.Creating a DSN Using iODBC Administrator (64-bit) To create or modify a DSN, you can either use the GUI iODBC Administrator app or edit the appropriate odbc.ini file. The odbc.ini file contains information about DSNs and is stored under the following path: See the Connection String options in the driver’s documentation for details about the parameters that can be set for each DSN. System DSN can be used by any user in the system who has proper rights. User DSN is created for a specific user and only the user who created it can see and use the DSN. There are two major types of DSN: User DSN and System DSN. To configure the installed ODBC driver on macOS, you can use a sample System DSN (data source name), which is created during the driver installation (for example, Devart_Oracle for Devart ODBC Driver for Oracle), or create your own DSN. Once the installation has been successfully completed, you will see the corresponding message. In the Installation Type, click Install.ĥ. In the Registration step, you can either enter your license code in the Activation Key field or select Trial if you would like to first evaluate the software. After reading the license agreement, click Continue, then Agree to proceed with the installation.ģ. In the Introduction and Read Me steps, click Continue.Ģ. You will need to allow opening the file by clicking Open Anyway under the General tab in System Preferences > Security & Privacy. Double-click on the installer file and follow the prompts. Devart drivers are compatible with 32-bit and 64-bit ODBC-compliant applications.ġ. pkg file is installed with the Apple Installer. You can find Devart ODBC drivers for macOS and download the needed driver as a. Installing an ODBC Driver on macOSįor the purposes of this article, we will install ODBC Driver for Oracle on macOS. After successful installation, you should be able to see the iODBC folder in the Applications folder. You will be guided through the steps necessary to install the iODBC Driver Manager. You should see that the installer you tried to open was blocked from opening. Under the General tab, click on the lock icon in the bottom left corner to unlock the settings. To resolve the issue, open System Preferences and choose Security & Privacy. You might get an error “iODBC-SDK.pkg can’t be opened because it is from an unidentified developer”. Double-click on the iODBC-SDK.pkg file and follow the instructions.Download iODBC and double-click on the mxkozzzz.dmg file.The driver manager is installed with its own GUI tool for creating a DSN, the iODBC Administrator. You can download the latest version of iODBC from the iODBC website. Most macOS installations do not come with a driver manager as part of the operating system, so you need to install it yourself. iODBC is a free and open source driver manager widely used on macOS, Linux, and Unix systems. Our drivers for macOS are compatible with the iODBC driver manager. Testing ODBC Connection to the Data Sourceīefore installing the driver, you need to make sure that your system has a driver manager installed.Creating a DSN by Adding Entries to the odbc.ini File.Creating a DSN Using iODBC Administrator (64-bit).This article covers the installation and configuration of Devart ODBC drivers on macOS. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |