Using The ROOT-Oracle Interface

I have been testing and evaluating the ROOT database interfaces (direct Oracle and ODBC-to-Oracle). My Notes and impressions are collected here.

See also Nick West's page on using ROOT SQL interfaces

1. Building and using the ROOT/Oracle native interface

2. Configuring the ROOT/ODBC interface for use with Oracle ODBC Drivers

3. Testing the ROOT/ODBC interface with Oracle ODBC Drivers

4. Problems detecting Oracle metadata for both ODBC and direct Oracle.

5. It was pointed out that my "Testing the ROOT/ODBC interface" link on item #3 above used the ASCII interface to the database, there is also a binary interface. I was unsuccessful in my first attempts at getting it to work. This is probably due to my not having the correct documentation at the time. See http://root.cern.ch/root/htmldoc//TSQLStatement.html#TSQLStatement:description for how it is supposed to work.

   Update (9/11/2006) I am still unable to get the ODBC binary interface to work with Oracle. Details here.