Sample Header Ad - 728x90

Trouble Connecting to SQL Anywhere through ODBC

1 vote
0 answers
926 views
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