RE: TSQLServer on Windows

From: Philippe Canal <pcanal_at_fnal.gov>
Date: Wed, 08 Jun 2005 09:02:27 -0500


Hi Marina,

The error might be coming from an obsolete rootrc file. In my $ROOTSYS/etc/system.rootrc (but you should also check for a local .rootrc or $HOME/.rootrc) I have:

system.rootmap:Library.TOracleServer:                      libOracle.dll
system.rootmap:Library.TOracleResult:                      libOracle.dll
system.rootmap:Library.TOracleRow:                         libOracle.dll
system.rootrc:+Plugin.TSQLServer: ^oracle: TOracleServer Oracle "TOracleServer(const char*,const char*,const char*)"

Note the 3 arguments for TOracleServer. I suspect that in your case this lines are not present or incorrect!

Cheers,
Philippe.
PS. For me, on windowd, the line you provide issue the correct:

Error in <TOracleServer::TOracleServer>: connection to Oracle database devdb10 failed (error: ORA-12154: TNS:could not r esolve the connect identifier specified
)

-----Original Message-----
From: owner-roottalk_at_pcroot.cern.ch [mailto:owner-roottalk_at_pcroot.cern.ch] On Behalf Of Marina Giunta
Sent: Monday, June 06, 2005 10:11 AM
To: roottalk_at_pcroot.cern.ch
Subject: [ROOT] TSQLServer on Windows

Hello,
I'm trying to use the ROOT- Oracle interface under Windows: I built the library using the latest CVS version of the oracle classes, I was able to build the library; then I tried to run the same macro I use on my Linux PC (where it works fine) and I get an error message at the line:  

TSQLServer *db =
TSQLServer::Connect("oracle://oradev10.cern.ch:10520/devdb10","user","passwo rd");  

the message is:

                Error in <TPluginHandler::ExecPlugin>: nargs (3) not consistent with expected nu

                mber of arguments ([0--1])

Does anyone know what the problem is?  

                   Marina
 
Received on Wed Jun 08 2005 - 16:02:59 MEST

This archive was generated by hypermail 2.2.0 : Tue Jan 02 2007 - 14:45:09 MET