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.

Procedure

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)

    Description

    Data Source Name

    <data_source_name>

    Data source name

    Caution Caution

    The name may not contain any special characters.

    End of the caution.

    Description

    -

    Description of the data source

    Database

    ServerDB

    Database name

    Server

    ServerNode

    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.

    SQLMode

    SQLMode

    SQL mode

    More information: Glossary, SQL Mode

    Isolation Level

    IsolationLevel

    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>]
ServerDB=<database_name>
ServerNode=<database_computer_name>
SQLMode=<INTERNAL|ORACLE>
TraceFileName=<trace_file_path_name>
    End of the code.

Result

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.