Re: [ROOT] I broke ROOT installing ODBC

From: George M. Irwin (gmieg@slac.stanford.edu)
Date: Tue May 11 2004 - 18:32:27 MEST


Hi John,
The ODBC installation instructions that Valeriy's Web page are pointing
to are the current instructions for Minos.  While the instructions are
really intended for Minos internal consumption, I believe that no one
in Minos has managed to "break ROOT" by installing unixODBC and MyODBC
on their computers.  The ROOT and ODBC installations would seem to be
independent of each other.  You might check whether the /usr/local/lib
that you added to your /etc/ld.so.conf might have something else that's
overriding what ROOT wants.  You could try putting /usr/local/lib later
in the list.  If you remove /usr/local/lib from the list, does ROOT
start working again?
George

On Tue, 11 May 2004, Dr. John Krane wrote:

> Hi Valeriy,
>
> >try to separate the problems.
> >Does it work with "pure ROOT" (without RDBC)?
> >
> I don't really understand what you are asking.  My setup is FLRH9.0 with
> ROOT 4.00/03 on two identical machines.  The ROOT commands in my
> original message used to create a new Pad and the text output "bbh" on
> both machines.  I tried to install ODBC functionality to ROOT by
> following the web page (skipping the MySQL steps, because I already have
> it).  Now the commands don't work on my machine any more.  To do any
> work with ROOT, I need to go over to the other machine where I have not
> tried the ODBC install.  (Luckily, my stand-alone programs, which use
> ROOT libraries, still function on the afflicted machine!)
>
> Somehow, during my ODBC install, I broke ROOT!  I did nothing all day
> except run my usual ROOT routines in the morning, attempt the install,
> and (try and fail to) run my *same* usual ROOT routines in the afternoon.
>
> Maybe I should just uninstall all the ODBC stuff.  (It is perhaps a bad
> sign for the "freshness" of the install instructions that your email
> address there does not work.)  I have already tried rebuilding with
> "gmake clean all, gmake install" in the ROOT area and got no joy.
>
>     - John
>
> >>Hi,
> >>
> >>I followed the instructions at
> >>
> >> http://www-numi.fnal.gov/offline_software/srt_public_context/WebDocs/install_products.html#MyODBC
> >>
> >>...which I found as the first link from Valeriy's page
> >>
> >>http://carrot.cern.ch/~onuchin/RDBC/download.html
> >>
> >>I installed unixODBC and MyODBC driver.  (I already have MySQL.)  The
> >>last thing I did was "add /usr/local/lib to /etc/ld.so.conf and run
> >>ldconfig".  Everything seemed to go fine.
> >>
> >>But now when I go into ROOT, the up-cursor does not provide the previous
> >>command, and ROOT does not recognize any of its own classes:
> >>
> >>root [0] new TCanvas     // nothing happens...
> >>root [1] TString a="bbh"
> >>root [2] cerr<<a<<endl;  // I get no output
> >>root [3]
> >>
> >>Does anybody know what I might have done wrong or how to fix it?  Or
> >>even what I should check?
> >>
> >>    - John
> >>
> >>
> >>Fons Rademakers wrote:
> >>
> >>
> >>
> >>>There is no direct TSQLServer plugin for MS SQL Server, but in principle
> >>>Valeriy Onochin's ODBC interface should be able to connect to MS SQL
> >>>Server.
> >>>
> >>>Cheers, Fons.
> >>>
> >>>
> >>>
> >>>On Mon, 2004-05-10 at 18:20, Dr. John Krane wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>Hi everyone,
> >>>>
> >>>>Just wanted to check if TSQLServer can Connect to a Microsoft SQL
> >>>>Server.  I see in the reference area:
> >>>>
> >>>>
> >>>>     Data Members
> >>>>
> >>>>   protected:
> >>>>
> >>>>     TString <http://root.cern.ch/root/html/TString.html> fType  type of DBMS (MySQL, Oracle, SysBase, ...)
> >>>>
> >>>>... etc.
> >>>>
> >>>>
> >>>>But I don't see Microsoft SQL Server 2000 (or SQL Server 7) listed.  Can
> >>>>anyone confirm please?
> >>>>
> >>>>   - John
> >>>>
> >>>>
> >>>>
> >>>>
> >>--
> >>
> >>Dr. John Krane
> >>jkrane@netzero.com
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>
> --
>
> Dr. John Krane
> jkrane@netzero.com
>
>
>



This archive was generated by hypermail 2b29 : Sun Jan 02 2005 - 05:50:08 MET