Could you please post your queries to respective Product(EDC) community ? This community is for Cloud Application Integration Product.
Thanks for your concern, but this seems to be the correct forum. Here is the path to this discussion:
Informatica Network > Data Engineering Integration > Enterprise Data Catalog > Discussions
Please let me know if this query should be posted in some other forum.
1 of 1 people found this helpful
This error usually occurs when environment variables related to ODBC is not configured correctly. Can you please check if $INFA_HOME/tomcat/temp/envvars.txt and make sure environment variables are considered during Informatica Services startup.
Sample Environment Variable Set (highlighted ones are important):
You need to restart Informatica Domain after setting these environment variables.
For SQL Server, you can connect with or without ODBC DSN. Refer Rules and Guidelines for Microsoft SQL Server for more details.
If you are connecting to SSL Enabled database, you should use ODBC DSN as connect String. If not, you can use following format as connect String:
if you are not aware please check also the ssgodbc test tool
For using DSN.
In addition to the very good points from Ganiga:
Again with ODBC and DSN true the key elements in your odbc.ini are (it's an older INFA version but should be fine)
Portnumber=<your port number, most likely 1433>
By usage of DSN the connection String can be anything and mut only resemble the entry in the odbc.ini
inuser518376 ! Couple more things to check
1. Reboot all the services, including domain?
2. Is there a LD_LIBRARY_PATH override (on the Admin Console > DIS > Process tab)?
3. Verify .bashrc is actually loaded, Echo the environment variable value
4. Have you put the env on userA's .bashrc and logged in as userB to restart the Domain earlier?
You can manually set the env variables on the shell and reboot the domain in the same shell (session).