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 [at] 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"

 <tt>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 
</tt>
 <tt>3.We tried to install the driver manager as well</tt>
 <tt> a.libiodbc-3.52.6 while make</tt>
 <tt> error :(Bundled) cc: "../include/sqltypes.h",
line 353: error 1000: Unexpected symbol: "long".</tt>
 <tt>(Bundled) cc: "../include/sql.h", line 788:
error 1000: Unexpected symbol: "SQLAllocConnect".</tt>
 <tt>(Bundled) cc: error 2017: Cannot recover from earlier
errors, terminating.</tt>
 <tt>*** Error exit code 1</tt>
 
 <tt>Stop.</tt>
 <tt>*** Error exit code 1</tt>
 
 <tt>b.unixODBC-2.2.12</tt>
 <tt> error:configure: checking for Qt</tt>
 <tt>checking for Qt headers... no</tt>
 <tt>configure: error: cannot find correct Qt headers!</tt>
 <tt> 
Please help us resolve the same</tt>
 
 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 [at] tcs.com 
Website: <a href=http://www.tcs.com/>http://www.tcs.com</a> 
____________________________________________ 
Experience certainty. IT Services 

Business Solutions 

Outsourcing 
____________________________________________<pre>=====-----=====-----=====
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

</pre>
--=_alternative 001D30B065257633_=--

--_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" <rohan.jamadagni [at] 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: 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 [at] tcs.com
Website: http://www.tcs.com <http://www.tcs.com/>
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
=3D=3D=3D=3D=3D-----=3D=3D=3D=3D=3D-----=3D=3D=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

<HTML>
<HEAD>
<TITLE>Re: [ODBC] Not able to connect from Informatica</TITLE>
</HEAD>
<BODY>
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" <<a href=3D"rohan.jamad=
agni [at] tcs.com">rohan.jamadagni [at] tcs.com</a>> wrote: 
 
<BLOCKQUOTE> 
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 
 a.libiodb=
c-3.52.6 while make 
 err=
or :(Bundled) cc: "../include/sqltypes.h", line 353: error 1000: =
Unexpected symbol: "long". 
(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. 
*** Error exit code 1<=
/FONT> 
 
Stop. 
*** Error exit code 1<=
/FONT> 
 
b.unixODBC-2.2.12</FON=
T> 
 error:configure=
: checking for Qt =
 
checking for Qt header=
s... no 
configure: error: cann=
ot 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: <a href=3D"rohan.jamadagni [at] tcs.com">rohan.jamadagni [at] tcs.com</a> 
Website: <a href=3D"http://www.tcs.com">http://www.tcs.com</a> <<a href=
=3D"http://www.tcs.com/">http://www.tcs.com/</a>> 
____________________________________________ 
Experience certainty. IT Services=
 
 &nb=
sp; Business Sol=
utions 
 &nb=
sp; Outsourcing<=
BR>
____________________________________________ 
=3D=3D=3D=3D=3D-----=3D=3D=3D=3D=3D-----=3D=3D=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 
 
 
 
</BLOCKQUOTE>
</BODY>
</HTML>

--_000_C6D7C38A1005ksellgreenplumcom_--

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

Hi,

There is an odbc.ini file located in the directory where you installed Info=
rmatica.
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 DS=
N info.

Just to make sure Informatica is using the correct files, create environme=
nt
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 th=
em up
when it starts.

......Ken

On 9/17/09 10:42 PM, "Rohan Jamadagni" <rohan.jamadagni [at] 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 manage=
r 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 [at] tcs.com
Website: http://www.tcs.com <http://www.tcs.com/>
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
=3D=3D=3D=3D=3D-----=3D=3D=3D=3D=3D-----=3D=3D=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_C6D906F1101Dksellgreenplumcom_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: [ODBC] Not able to connect from Informatica &n=
bsp;</TITLE>
</HEAD>
<BODY>
Hi, 
 
There is an odbc.ini file located in the directory where you installed Info=
rmatica. 
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 DS=
N info. 
 
Just to make sure Informatica is using the correct files, create envi=
ronment 
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 th=
em up 
when it starts. 
 
......Ken 
 
 
 
On 9/17/09 10:42 PM, "Rohan Jamadagni" <<a href=3D"rohan.jamad=
agni [at] tcs.com">rohan.jamadagni [at] tcs.com</a>> wrote: 
 
<BLOCKQUOTE> 
Hi Ken 
 
Thanks for the update 
While i am able to debug the driver manager related error (psqlodbc-0=
8.01.0200) 
I am still getting error related to ODBC ( no suitable ODBC dri=
ver 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: <a href=3D"rohan.jamadagni [at] tcs.com">rohan.jamadagni [at] tcs.com</a> 
Website: <a href=3D"http://www.tcs.com">http://www.tcs.com</a> <<a href=
=3D"http://www.tcs.com/">http://www.tcs.com/</a>> 
____________________________________________ 
Experience certainty. IT Services=
 
 &nb=
sp; Business Sol=
utions 
 &nb=
sp; Outsourcing<=
BR>
____________________________________________ 
=3D=3D=3D=3D=3D-----=3D=3D=3D=3D=3D-----=3D=3D=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 
 
 
 
</BLOCKQUOTE>
</BODY>
</HTML>

--_000_C6D906F1101Dksellgreenplumcom_--

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

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 [at] 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 001F56E765257635_=
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset="us-ascii"

 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 [at] tcs.com 
Website: <a href=http://www.tcs.com/>http://www.tcs.com</a> 
____________________________________________ 
Experience certainty. IT Services 

Business Solutions 

Outsourcing 
____________________________________________<pre>=====-----=====-----=====
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

</pre>
--=_alternative 001F56E765257635_=--

Not able to connect from Informatica

Re: Not able to connect from Informatica

Re: Not able to connect from Informatica

Re: Not able to connect from Informatica