Procedure documentationCreating or Changing Data Sources Locate this document in the navigation structure


To access SAP MaxDB databases via the ODBC interface, create data sources for the databases.


You can use a driver manager to create or change data sources. On Unix and Linux, you can create or change data sources without a driver manager as well.

On Microsoft Windows, the definitions of data sources are stored in the registry; on Unix and Linux, they are stored in configuration files in the file system.

Creating Data Sources in the Driver Manager
  1. Open your driver manager.

  2. Select the SAP MaxDB ODBC driver (ASCII or Unicode).

  3. Specify the properties of the SAP MaxDB data source.

    Properties of Data Sources

    Property (Microsoft Windows)

    Property (Unix and Linux)


    Data Source Name


    Data source name

    Caution Caution

    The name may not contain any special characters.

    End of the caution.



    Description of the data source



    Database name



    Name of the database computer

    Note that if the SAP MaxDB database is located on the same computer as the ODBC application, you can leave this entry empty.



    SQL mode

    More information: Glossary, SQL Mode

    Isolation Level


    Locking behavior

    More information: Concepts of the Database System, Isolation Level

For more information, see the documentation provided by the manufacturer of the driver manager.

Creating Data Sources Without a Driver Manager (only on Unix and Linux)

Details about ODBC data sources are either stored globally in the configuration file /etc/odbc.ini or user-specific in the file /<user_home>/.odbc.ini. The system searches for data sources first in the user-specific configuration file, then in the global configuration file.

  1. Open the configuration file in a text editor.

  2. Specify the properties of the data source as follows:

    Syntax Syntax

    1. [<data_source_name>]
    End of the code.


When you make changes to a data source, these changes become effective the next time you log on to the database via the ODBC interface.