Not able to connect from Informatica

[Rohan jamadagni]

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@...
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

[Ken Sell]

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.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: 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@...
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

[Rohan jamadagni]

Hi Ken

Thanks for the update
While i am able to debug the  driver manager related error (psqlodbc-08.01.0200)
I am still getting error related to ODBC  (  no suitable ODBC driver manager found)
Is it like i have to define the driver manager name and location some where.
Or I am using a wrong ODBC or manager.
I will try the same on a different setup to ensure the same

Appreciate your time and help.

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@...
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

[Ken Sell]

Hi,

There is an odbc.ini file located in the directory where you installed Informatica.
The DataDirect Driver manager is there as well.

Before you start Informatica (i.e. infa_services.sh startup) set up you lib path
to point to the driver manager.

Edit that odbc.ini file and odbcinst.ini file to include your driver and DSN info.

Just to make sure Informatica is using the correct files, create  environment
variables ODBCINI and ODBCINST and point them to the odbc.ini and odbcinst.ini
files respectivly. Make sure that it is done such that Informatica picks them up
when it starts.

.....Ken



On 9/17/09 10:42 PM, "Rohan Jamadagni" <rohan.jamadagni@...> wrote:

Hi Ken

Thanks for the update
While i am able to debug the  driver manager related error (psqlodbc-08.01.0200)
I am still getting error related to ODBC  (  no suitable ODBC driver manager found)
Is it like i have to define the driver manager name and location some where.
Or I am using a wrong ODBC or manager.
I will try the same on a different setup to ensure the same

Appreciate your time and help.

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@...
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