Sudo /Applications/iODBC/iODBC\ Administrator64.app/Contents/MacOS/iODBC\ Administrator64Īfter opening the iODBC Administrator 64-bit, you will see the CData Excel Source listed under the System tab. To do so, enter the following command into a terminal:
#Excel odbc manager driver#
To modify the system DSN installed by the driver or create a system DSN, open the iODBC Administrator 64-bit with elevated permissions. You can create user DSNs by opening the iODBC Administrator 64-bit from Launchpad. System data sources can be accessed by all users.Ĭonfiguring a DSN with the iODBC Administrator User data sources are restricted to a user account. Alternatively, you can edit the iODBC configuration files. The most recent version of the CData ODBC Driver for Excel is 64-bit only.
Note that the ODBC Manager must match the bitness of the ODBC driver. To configure a DSN, you can use the iODBC Administrator 64-bit, the GUI installed with iODBC. The driver must be registered with the driver manager and DSNs are defined in the driver manager's configuration files. The driver manager loads the driver and passes function calls from the application to the driver.
The driver installation registers the driver with iODBC and creates a system DSN, which you can use in any tools or applications that support ODBC connectivity. You can find the latest version of iODBC on the iODBC site. On macOS, the CData ODBC Driver for Excel is preconfigured for use with the iODBC driver manager, as are many other products like Filemaker Pro, Microsoft Excel, and Tableau.
0 kommentar(er)
