Is there any documentation on the configuration of the SAP/Sybase ODBC Manager under Linux, the only documentation I found says it exists and the install places entries in the {home}/.odbc.ini file? Is there an odbcinst.ini file somewhere and/or an odbc.ini for system wide instead of user based entries? What does one need to tell other non-SAP/Sybase applications that the system is using the SAP/Sybase ODBC manager (like wine for example)? Another alternative -- The documentation says that unixODBC >= 2.2.14 can be used as the ODBC manager. Does anyone know how SAP/ Sybase applications are told unixODBC and not the default SAP/Sybase is the ODBC manager for this system? (What is the recommended contents of odbcint.ini for SQL Anywhere 16, if not identified above?) asked 17 Sep '13, 19:57 pasha19 |
Let's start with general ODBC linking on Linux: When you compile/link your generic ODBC program on Linux, you will typically specify ( Sidenote: if you didn't want to use unixODBC as a driver manager, and instead picked yet another third-party ODBC driver manager like iODBC, whichever
The SQL Anywhere ODBC Driver for Unix is the shared library ln -s $SQLANY16/lib64/libodbc.so $SQLANY16/lib64/libdbodm16.so and ensure that the You could also link directly against our ODBC driver file by specifying
According to the unixODBC page regarding the topic of interfacing with Wine, Wine is linking against a natively running answered 28 Nov '13, 15:12 Jeff Albion |
I was better at finding documentation this morning:
Wine ODBC Environment Variable LIB_ODBC_DRIVER_MANAGER
SAP/Sybase ODBC Manager libdbodb16.so which can be found as a link in both /opt/sqlanywhere16/lib{32&64}/
I am going to try using the SAP/Sybase ODBC Manager for now with the Unix ENVIRONMENT variable for Wine and see what happens. I still need to figure which one I use to open 32bit clients from Wine. My first try will be the lib64 manager with the ini file specifying the bin64 start and the lib32 ODBC driver.
Sybase uses the following environment variables ODBCHOME, HOME and either ODBC_INI or ODBCINI
ODBCHOME is used to specify the location of the system .odbc.ini file HOME is used to specify the location of the user .odbc.ini file
ODBCINI and ODBC_INI can be used with full paths when the odbc.ini file is not named .odbc.ini
I could never get this to work with wine and adopted another approach.