I'm trying to connect to a SQL Anywhere database through an an ODBC connection on my Mac (running High Sierra).
I downloaded and installed the SQL Anywhere 17 Developer edition. Installed it successfully. I can launch it connect to my databases. Yay!
Next, I downloaded and installed the ODBC Administrator I read about in multiple posts. Installed it... seems to run as intended.
Next I added the SQL Anywhere 17 drivers to the ODBC Administrator (by following these steps .
Then I tried adding a DSN (tested both User and System). The documentation on this is a little lacking from SYBASE (specifically which parameters are "required"). Depending on what version of help you're looking at, the examples use different parameters. In the end, I created parameters for the all the variables passed in the connection string (UserID, Password, Database File). Sadly, there's no testing function in the ODBC Administrator to test a DSN.
So I return to SQL Anywhere and attempt to connect to a database via "Connect with an ODBC Data Source". Here, I can "Test Connection". And I consistently get the error: "[SAP][ODBC Driver Manager] Unable to load driver libodbc.dylib"
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. Now I have no idea what a bundle file is. Does it contain a 'bundle' of drivers? No idea. 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.
I'm relatively new to Mac OS (I've done this a million times in Windows). Please, if anyone can help me with what I assume should be a fairly simple task, I would be eternally grateful.
Asked by mts1701
(11 rep)
Jul 5, 2018, 09:40 PM
Last activity: Jan 11, 2023, 12:52 PM
Last activity: Jan 11, 2023, 12:52 PM