RE: MaxDB Connection

Hi, Kerry

I've never work with SapDB, therefore I cannot say anything about it's performance with ODBC and with native driver. Usually, performance of all DB-drivers limited by the network, not by the type of API. In case of ROOT SapDB plugin it should be no difference at all compare with ROOT ODBC plugin, while both are internally build on the top of ODBC API. Advantage of TODBCServer - it supports more feauters like statements, binary data types and so on.

Regards,
Sergey

 -----Original Message-----
From: Lee, Kerry T. (JSC-SF)[LMIT] [mailto:kerry.t.lee_at_nasa.gov] Sent: Freitag, 5. Oktober 2007 17:22
To: Linev Sergei; roottalk_at_pcroot.cern.ch Subject: RE: [ROOT] MaxDB Connection

Sergey,

Thanks, that worked! I was told that there is a possiblility that using ODBC may be a little slow since it is not the native "tougue" of MaxDB. Do you have any experience with the performance using this method?

Thanks
Kerry

-----Original Message-----
From: Linev Sergei [mailto:S.Linev_at_gsi.de] Sent: Fri 10/5/2007 8:54
To: Lee, Kerry T. (JSC-SF)[LMIT]; roottalk_at_pcroot.cern.ch Subject: RE: [ROOT] MaxDB Connection

Hi, Kerry

Can you try to use ROOT ODBC driver.
As far as I know, SapDB driver in ROOT anyhow implemented via ODBC interface. Just call it as follow:

TSQLServer* serv = TSQLServer::Connect("odbcd://DRIVER={MaxDB};SERVER=141.108.250.103;DATABASE=;UID=;PWD=","","");

Some databases instead of UID and PWD required USER and PASSWORD arguments in connection string. See some more possibilities for ODBC connection here:

http://root.cern.ch/root/html/TODBCServer.html#TODBCServer:TODBCServer

Regards,
Sergey

-----Original Message-----
From: owner-roottalk_at_root.cern.ch [mailto:owner-roottalk_at_root.cern.ch] On Behalf Of Lee, Kerry T. (JSC-SF)[LMIT] Sent: Freitag, 5. Oktober 2007 14:29
To: roottalk_at_pcroot.cern.ch
Subject: [ROOT] MaxDB Connection

Dear ROOTers,

I am using the latest released version 5.17.02 on CentOS linux.

I am trying to connect to a MaxDB database via TSapDBServer and I get the following error (I have excluded the DATABASE name, UID and PWD values below)

root [0] gSystem.Load("$ROOTSYS/lib/libRODBC.so")
(int)0

root [1] gSystem.Load("$ROOTSYS/lib/libSapDB.so")
(int)0

root [2] TSapDBServer *server =new TSapDBServer("sapdb://DRIVER={MaxDB};SERVER=141.108.250.103;DATABASE=;UID=;PWD=","","");

SQL state: r
SQL code: 15
SQL Errortext:

Error in <TSapDBServer::TSapDBServer>: allocation of db failed

I am using the libsqlod.so driver and have been able to connect via the commandline using

isql -v DATASOURCENAME UID PWD

so I am somewhat confindent that at least the driver is working properly.

Any help is appreciated.

Thanks
Kerry Received on Fri Oct 05 2007 - 18:22:51 CEST