This section provides information about the unixODBC driver manager and the SAP MaxDB ODBC driver.
Let us assume, that on your Linux box unixODBC is already installed (some distributions contain unixODBC by default), and you want to use it with the SAP MaxDB ODBC driver.
Check for installation, when using unixODBC, please install release 2.3.0 or later (check with "isql --version")
Here, unixODBC version 2.3.0 is installed. "isql" is a query tool of unixODBC.
- Check for the MaxDB ODBC driver:
unixODBC needs the driver as shared library usually denoted by the suffix ".so". The MaxDB ODBC driver until release 7.6 has the name libsqlod.so and libsdbodbc.so for release 7.7 and following.
Define a DSN (data source name) for using with unixODBC: unixODBC looks for user specific definitions in the user's home directory in the file ".odbc.ini" (note the leading dot in the file name). The search order for ODBCINI is:
1. Evaluate the $ODBCINI variable as filename for DSN definitions
. I.e. you do not need administration rights to use the MaxDB ODBC driver. Edit "~/.odbc.ini" and add following example defining a DSN "largedb":
Test your DSN with isql assuming that the user ODBC exists with password ODBC:
- That's all!
This example serves only as a very first step to use the MaxDB ODBC driver with unixODBC. For more details (usage and administration of unixODBC) please look at http://www.unixodbc.org