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