Question about accessing a Postgres DBserver from a ROOT-based application

Dear ROOT team,

I am chasing down a problem with accessing a local Postgres DB server using ROOT-based collaboration software. The server seems to be accessible well enough using psql interactive commands, and the collaboration software has worked with this server at least as of a year ago.

First question: a connection error is being reported by a method which returns a TSQLConnection
class member. Is the TSQLConnection class a ROOT class. I did not find it in the list http://root.cern.ch/root/html/ClassIndex.html , although someone suggested to
me that it was a ROOT class. Possibly there is a library mis-match somewhere.

Second question: is there a simple closed, macro example in the ROOT documentation of
making a connection to a Postgres server with the TSQLServer class. I did see some mails
(e.g. June 10, 2003) referring to this capability, but was looking for a canned example.

Hope the description is precise enough. I am chasing the other usual suspects (e.g.
.odbc.ini file) too.

Thanks,
Charlie Maguire Received on Wed Aug 20 2008 - 20:38:42 CEST