Not able to connect from Informatica

This is a multipart message in MIME format.
--=_alternative 001D30B065257633_=
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="us-ascii"

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.jamadagni@tcs.com
Website: 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



--=_alternative 001D30B065257633_=
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset="us-ascii"



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.jamadagni@tcs.com

Website:

____________________________________________

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

Re: Not able to connect from Informatica

--_000_C6D7C38A1005ksellgreenplumcom_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 yo=
u start up Informatica).

....Ken



On 9/15/09 10:18 PM, "Rohan Jamadagni" 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: Unex=
pected 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.jamadagni@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
=====3D-----=====3D-----=====3D
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




--_000_C6D7C38A1005ksellgreenplumcom_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






11pt'>Hi,



I can’t really tell what is wrong here, but I have connected to Postg=
reSQL 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 yo=
u start up Informatica).



....Ken







On 9/15/09 10:18 PM, "Rohan Jamadagni" < agni@tcs.com">rohan.jamadagni@tcs.com> wrote:

>

r New, Courier">PostgreSQL version: 8.3.7

 Operating system:   Linux Rhel 5.0

 Description:        Not able to co=
nnect 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 foll=
owing

 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 Arial">

  a.libiodb=
c-3.52.6  while  make tica, Arial">

   err=
or :(Bundled) cc: "../include/sqltypes.h", line 353: error 1000: =
Unexpected symbol: "long". Helvetica, Arial">

(Bundled) cc: "..=
/include/sql.h", line 788: error 1000: Unexpected symbol: "SQLAll=
ocConnect". <=
BR>
(Bundled) cc: error 20=
17: Cannot recover from earlier errors, terminating. libri, Verdana, Helvetica, Arial">

*** Error exit code 1<=
/FONT>



Stop. =3D"Calibri, Verdana, Helvetica, Arial">

*** Error exit code 1<=
/FONT>



b.unixODBC-2.2.12 T>

 error:configure=
: checking for Qt =


checking for Qt header=
s... no

configure: error: cann=
ot find correct Qt headers! , Arial">



 Please help us resolve the same Helvetica, Arial">



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:

Website: < =3D"http://www.tcs.com/">http://www.tcs.com/>

____________________________________________

Experience certainty.        IT Services=


            &nb=
sp;          Business Sol=
utions

            &nb=
sp;          Outsourcing<=
BR>
____________________________________________

=====3D-----=====3D-----=====3D

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