To do so, enter the following command into a terminal: 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 OData 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 OData is preconfigured for use with the iODBC driver manager, as are many other products like Filemaker Pro, Microsoft Excel, and Tableau. These refer to your name and your machine's password. You'll be prompted for a name and password. To activate a trial, omit the input.Ĭd "/Applications/CData ODBC Driver for OData/bin" In a terminal, run the following commands to license the driver. The CData ODBC Driver for OData driver requires macOS Sierra (10.12) or above. Please, if anyone can help me with what I assume should be a fairly simple task, I would be eternally grateful.This section shows how to set up ODBC connectivity and configure DSNs on macOS. I'm relatively new to Mac OS (I've done this a million times in Windows). But unless this bundle file is supposed to contain libodbc.dylib (the file/driver reported as missing) then it's worth mentioning that file doesn't even exist on my Mac I've searched for it. Does it contain a 'bundle' of drivers? No idea. Now I have no idea what a bundle file is. One thing I noticed is that when I added the SQL Anywhere 17 driver, I point (per the instructions) to: /Applications/SQLAnywhere17/System/lib64/dbodbc17.bundle. ![]() And I consistently get the error: " Unable to load driver libodbc.dylib" So I return to SQL Anywhere and attempt to connect to a database via "Connect with an ODBC Data Source". Sadly, there's no testing function in the ODBC Administrator to test a DSN. ![]() In the end, I created parameters for the all the variables passed in the connection string (UserID, Password, Database File). Depending on what version of help you're looking at, the examples use different parameters. The documentation on this is a little lacking from SYBASE (specifically which parameters are "required"). Then I tried adding a DSN (tested both User and System). Next I added the SQL Anywhere 17 drivers to the ODBC Administrator (by following these steps. Next, I downloaded and installed the ODBC Administrator I read about in multiple posts. I downloaded and installed the SQL Anywhere 17 Developer edition. I'm trying to connect to a SQL Anywhere database through an an ODBC connection on my Mac (running High Sierra).
0 Comments
Leave a Reply. |