Error connecting to an Oracle DB

From: Antonio Bulgheroni <antonio.bulgheroni_at_gmail.com>
Date: Thu, 28 Sep 2006 17:13:32 +0200


Dear ROOTers,

        I'm writing you because I'm in troubles connecting to an Oracle server using ROOT. It looks like the plug-in is correctly loaded but then something is wrong when the plugin is executed. Here below a very short example and the corresponding ROOT output. Hostname, user and password are hided for privacy

void DBConnect() {

gSystem->Load("libSQL");
gSystem->Load("libclntsh");
gSystem->Load("libOracle.so");

const char * hostname = "oracle://hostname/db";
const char * uid           = "pippo";
const char * pass        = "***********";

TSQLServer* serv = TSQLServer::Connect(hostname, uid, pass); }

And this is the output

Error in <TOracleServer::TOracleServer>: Code: 12154 Msg: ORA-12154: TNS:could not resolve the connect identifier specified

I'm using ROOT 5.13.02 on a SLC4 linux box libocci 10.1

Thanks for yuor help!

Antonio

-- 
Antonio Bulgheroni, PhD

Turn your Pentium II into a Gameboy: Type WIN at C:\>
Received on Thu Sep 28 2006 - 17:13:40 MEST

This archive was generated by hypermail 2.2.0 : Mon Jan 01 2007 - 16:32:01 MET