Hi Djamel, I would be helpfulll (for experts) to get the code/script you are actually trying to use. I find the specifics of your question a bit broad. Flemming ---------------------------------------------------------------- Flemming Videbaek Physics Department Brookhaven National Laboratory e-mail: videbaek@bnl.gov phone: 631-344-4106 ----- Original Message ----- From: "Djamel Ouerdane" <ouerdane@nbi.dk> To: "Brahms Devel List" <brahms-dev-l@lists.bnl.gov> Sent: Monday, March 22, 2004 8:46 AM Subject: [Brahms-dev-l] database connections > Hi, > > A question to the DB experts (in fact, developers who implemented the brat > interface to the sql DB's): > > let's say I have a bratroot script that connects once to the DBs (main, > runs and calibs, standard way). If at some point, I choose not to do > anything with them but don't want to quit the job, how do I eventually > reconnect to the DBs ? Do I need at all to reconnect if in a 2nd pass I > want to do something with the DBs ?? Because right now, when I come back > to the connection, it fails miserably saying: > > Error in <TMySQLServer::TMySQLServer>: connection to database RUNDB on > pii3.brahms.bnl.gov failed (error: Access denied for user: > 'ouerdane@hilux02.nbi.dk' (Using password: YES)) > Error in <BrRdbmDb::Connect>: User couldn't connect to database RUNDB @ > pii3.brahms.bnl.gov > Error in <BrRdbmMainDb::ConnectToDb>: couldn't connect to database RUNDB > > > I tried to play with: if (maindb->IsConnected()) blablabla but no success. > > Thanks for tips. > > Djam > > > -- > Djamel Ouerdane ------------------------------------------o > | Niels Bohr Institute | Home: | > | Blegdamsvej 17, DK-2100 Ø | Jagtvej 141 2D, | > | Fax: +45 35 32 50 16 | DK-2200 Copenhagen N | > | Tel: +45 35 32 52 69 | +45 35 86 19 74 | > | http://www.nbi.dk/~ouerdane | > | ouerdane@nbi.dk | > o---------------------------------------------------------o > > > _______________________________________________ > Brahms-dev-l mailing list > Brahms-dev-l@lists.bnl.gov > http://lists.bnl.gov/mailman/listinfo/brahms-dev-l > _______________________________________________ Brahms-dev-l mailing list Brahms-dev-l@lists.bnl.gov http://lists.bnl.gov/mailman/listinfo/brahms-dev-lReceived on Mon Mar 22 09:01:43 2004
This archive was generated by hypermail 2.1.8 : Mon Mar 22 2004 - 09:01:59 EST