On 2/12/2009 4:03 AM, Daniela Mamede d'Almeida wrote:
> Hi!
> I'm trying to connect an Oracle Db with a PostgreSQL Db, by means of
> Oracle heterogeneous service.
> I've installed (in my oracle server) DG4ODBC which is the oracle
> gateway, UnixODBC which is the driver manager... and all I need now is
> the PostgreSQL driver. I've downloaded psqlodbc... but I can't
> "configure" it as it says that theres a missing variable ...
> "PG_CONFIG".
Possible hints:
http://www.google.com.au/search?q="PG_CONFIG"+"unixodbc"
Particularly:
http://cpansearch.perl.org/src/RKIES/UnixODBC-0.34/dbms/README
... which suggests that you must specify PG_CONFIG as an environment
variable when calling configure:
# export PG_CONFIG=/usr/local/pgsql/bin/pg_config
# ./configure
(adjust PG_CONFIG for the location of pg_config on your system).
--
Craig Ringer