MaxDB

Table of contents 1 Info 2 Using 2.1 Connection String 2.1.1 Connection String Format 2.1.2 Connection String Parameters 2.2 C# Example 2.2.1 Source code 2.2.2 Building Example 2.2.3 Running the Example

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).

• Home site is [http://www.sourceforge.net/projects/maxdbprovider

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