Re: [ROOT] I broke ROOT installing ODBC

From: Dr. John Krane (jkrane@netzero.com)
Date: Tue May 11 2004 - 15:28:08 MEST


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