Re: [ROOT] trying to connect to ODBC db now...

From: Valeriy Onuchin (Valeri.Onoutchine@cern.ch)
Date: Wed May 12 2004 - 12:22:27 MEST


 Hi John,
actually this discussion is not ROOT related (although there is a chance that RDBC would 
be in ROOT someday). 

> Hi guys,
> 
> The problem was I filled my disk drive to bursting trying to install all 
> this.  Now that I moved stuff, ROOT works again.
> 
> But I am stuck trying to connect to the ODBC database.  I have 
> previously used c++ commands like:
> 
>     TSQLServer *serv=0;
>     serv = 
> TSQLServer::Connect("mysql://cpc-tmt6.paxclearing.com/taq","user","password");
> 
> ...to access a MySQL database, but I don't know the protocol to get to 
> the ODBC (specifically, a Microsoft) database.  It won't be "mysql:" 

You can connect to M$ SQLServer via DSN as
    TSQLServer::Connect("your_MS_SQL_DSN");
Check also http://www.freetds.org/
http://www.unixodbc.org/doc/FreeTDS.html

Regards. Valeriy



 
> anymore, right?  But "odbc:" doesn't work, nor many other things I have 
> tried.  The ROOT website implies it is possible in the v3.02 release 
> notes but shows no examples.  Anybody have an example that works?
> 
>     - John
> 
> -- 
> 
> Dr. John Krane
> jkrane@netzero.com
> 
> 
> 



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