MaxDB Connection

• Download MAXDBTest - 62.69 KB

Introduction

I have noticed a very small amount of support available for MaxDB. I have had the need to interface a dot net application to MaxDB for for the following reasons:

1. MaxDB is our SAP backend and I can host my database on the SAP server eliminating the need to me to do further maintenace on a new db.

2. Performance of the SAP database server.

3. The database is free :)

Using the code

The code is pritty simple. All the application does is connect ot a MaxDB database.

SQLConnection is obviously out of the question as it only connects to a SQL server, So I have used the next best thing. Odbc connection. The reason for this is I can have my data access seperate from my business logic and as such still you data tables and adapters.

OdbcConnection con = new OdbcConnection("driver=sap db;servernode=" + txtServer.Text + ";serverdb=" + txtDatabase.Text +
                                                    ";uid=" + txtUserName.Text.ToUpper() + ";pwd=" + txtPassword.Text.ToUpper());
            try
            {
                con.Open();
                MessageBox.Show("Successfully connected to Database");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            } 

Hope this helps someone ... basically all it is is a connection string for MaxDB.