Re: Not able to connect from Informatica

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(dot)jamadagni(at)tcs(dot)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(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