This page is likely outdated (last edited on 23 Sep 2006). Visit the new documentation for updated content.

MaxDB

Table of contents

Info

MaxDBProvider is ADO.NET data provider on .NET and Mono for the SAP-certified open source database MaxDB 7.5/7.6 (see MaxDB).

MaxDBProvider]

  • Can access MaxDB server either using native network protocol directly or

through corresponding client library

  • Namespace MaxDB.Data and assembly MaxDB.Data.dll

Using

Connection String

Connection String Format

Server=localhost;Database=Test;User ID=MyLogin;Password=MyPwd;

Connection String Parameters

Parameter Definition

Description

Example

Data Source or Server or Address or
Addr or Network Address

Hostname or IP Address of the MaxDB server

Server=myhost

Initial Catalog or Database

Name of MaxDB database

Database=testdb

User ID or Login

Name of MaxDB database user

Login=MyLogin

Password or PWD

Password of MaxDB database user

Password=MyPass

Mode

Internal or Oracle. MaxDB database mode. Default = Internal

Mode=Oracle

Pooling

True or False. Controls whether connection pooling is used. Default = True

Pooling=True

Min Pool Size

Min size of connection pool. Default: 1

Min Pool Size=1

Max Pool Size

Max size of connection pool. Default: 20

Max Pool Size=20

Connection Lifetime or
Load Balance Timeout

Connection lifetime in the connection pool (in seconds). Default: 0

Connection Lifetime=20

The Server connection string parameter can be used in two different ways:

Server Definition

Example

hostname

Server=localhost

hostname:port

Server=localhost:7210

C# Example

Source code

using System;
using System.Data;
using MaxDB.Data;
 
public class Test
{
  public static void Main(string[] args)
  {
    string connectionString =
      "Server=localhost;" +
      "Database=test;" +
      "User ID=scott;" +
      "Password=tiger;";
    IDbConnection dbcon = new MaxDBConnection(connectionString);
    dbcon.Open();
    IDbCommand dbcmd = dbcon.CreateCommand();
    // requires a table to be created named employee
    // with columns firstname and lastname
    // such as,
    //        CREATE TABLE employee (
    //           firstname varchar(32),
    //           lastname varchar(32));
    string sql =
      "SELECT firstname, lastname " +
      "FROM employee";
    dbcmd.CommandText = sql;
    dbcmd.Connection = dbcon;
    IDataReader reader = dbcmd.ExecuteReader();
    while (reader.Read())
    {
      string FirstName = (string)reader["firstname"];
      string LastName = (string)reader["lastname"];
      Console.WriteLine("Name: " +
        FirstName + " " + LastName);
    }
    // clean up
    reader.Dispose();
    reader = null;
    dbcmd.Dispose();
    dbcmd = null;
    dbcon.Dispose();
    dbcon = null;
  }
}

Building Example

Save the example to the file TestExample.cs and compile it

mcs TestExample.cs -r:System.Data.dll -r:MaxDB.Data.dll

Running the Example

mono TestExample.exe