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.
Open your driver manager.
Select the SAP MaxDB ODBC driver (ASCII or Unicode).
Specify the properties of the SAP MaxDB data source.
Property(Microsoft Windows) |
Property(Unix and Linux) |
Description |
---|---|---|
Data Source Name |
<data_source_name> |
Data source name 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.
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.
Open the configuration file in a text editor.
Specify the properties of the data source as follows:
Syntax
[<data_source_name>] ServerDB=<database_name> ServerNode=<database_computer_name> SQLMode=<INTERNAL|ORACLE> TraceFileName=<trace_file_path_name>
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.