Creating/Changing a Data Source

Use

To access a MaxDB database instance via the OBDC interface, you have to create a data source for the MaxDB database instance.

You can use a driver manager to create or change a data source. On UNIX/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/Linux, they are stored in configuration files in the file system.

Creating a Data Source in the Driver Manager

...

       1.      Choose the MaxDB ODBC driver.

       2.      Specify the properties of the MaxDB data source.

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

Creating a Data Source Without a Driver Manager (only on UNIX/Linux)

On UNIX/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 desired configuration file in an editor.

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

[<data_source_name>]

ServerDB=<database_name>

ServerNode=<database_computer_name>

SQLMode=<INTERNAL|DB2|ANSI|ORACLE>

IsolationLevel=<Uncommitted|Committed|Repeatable|Serializable>

TraceFileName=<trace_file_path_and_name>

If the application with which you want to access the database instance using the ODBC driver is located on a different computer than the database instance itself, the MaxDB X Server has to be running on the database computer. See Concepts of the Database System, Architecture of the Interfaces and X Server, Ports and Protocols of the X Server.

Result

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

See also:

Using the MaxDB ODBC Driver