Re: Not able to connect from Informatica

Hi,

I can't really tell what is wrong here, but I have connected to PostgreSQL form Informatica before using ODBC.
It did work.

You might want to try connecting via ODBC outside of Informatica first just to make sure your environment
is set up correctly. (e.g. you must have libpq in your library path when you start up Informatica).

...Ken

On 9/15/09 10:18 PM, "Rohan Jamadagni" <rohan(dot)jamadagni(at)tcs(dot)com> wrote:

PostgreSQL version: 8.3.7
Operating system: Linux Rhel 5.0
Description: Not able to connect from Informatica
Details:

Hi
We are trying to connect informatica(on HP-ux 11.23) to
postgres server with ODBC driver while configuring we are facing following
error
1.For psqlodbc-08.04.0100
pg_config not found (set PG_CONFIG environment variable)

2.For psqlodbc-08.01.0200
error: no suitable ODBC driver manager found

3.We tried to install the driver manager as well
a.libiodbc-3.52.6 while make
error :(Bundled) cc: "../include/sqltypes.h", line 353: error 1000: Unexpected symbol: "long".
(Bundled) cc: "../include/sql.h", line 788: error 1000: Unexpected symbol: "SQLAllocConnect".
(Bundled) cc: error 2017: Cannot recover from earlier errors, terminating.
*** Error exit code 1

Stop.
*** Error exit code 1

b.unixODBC-2.2.12
error:configure: checking for Qt
checking for Qt headers... no
configure: error: cannot find correct Qt headers!

Please help us resolve the same

Regards
Rohan Milind Jamadagni
Tata Consultancy Services
Vidyasagar Building,
2nd Floor, Raheja Township,
Near Sai Baba Mandir, Malad(E),
Mumbai - 400 097,Maharashtra
India
Mailto: rohan(dot)jamadagni(at)tcs(dot)com
Website: http://www.tcs.com <http://www.tcs.com/>
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you