Thread: Not able to connect from Informatica
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
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@tcs.com> wrote:
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@tcs.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.jamadagni@tcs.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
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@tcs.com> wrote:
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@tcs.com> 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@tcs.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
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@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