5 Replies Latest reply on Sep 15, 2020 9:26 AM by Madhusoodan Pataki

    Error in ODBC Connection for Data Access in EDC

    Anubhav Srivastava Active Member

      Hi Team,

       

      We are struggling with the ODBC connection for Data Access in EDC. Due to this we are unable to Profile data using Native type, neither can this be used in Analyst tool to create a reference table. Here is the error message.

      We have all the parameters in place such as ODBCHOME and ODBCINST.

       

      The Analyst tool cannot display the data preview because of an internal error. Contact an administrator or check the Analyst Service logs.

       

      [LDTMCMN_0029] The LDTM could not complete the request because of the following error: com.informatica.sdk.dtm.ExecutionException: [EdtmExec_00007] RR_4036 Error connecting to database [

      523 630

      Database driver error...

      Function Name : Connect

      Database driver error...

      Function Name : Connect

      Database Error: Failed to connect to database using user [IICS] and connection string [<ip>,1433].].

       

      I have changed the actual IP address with <ip>. Also tried with the host name, but no luck.

       

      I have been through following articles, but none of them worked.

      https://kb.informatica.com/solution/23/pages/64/525238.aspx#

      https://kb.informatica.com/solution/23/Pages/61/509150.aspx#

      571500

       

      If anybody faced the same issue, please let me know what can be done here, I have tried many different combinations but same error.

       

      Regards,

      Anubhav

        • 1. Re: Error in ODBC Connection for Data Access in EDC
          Prakash Jain Guru

          Hi Anubhav,

           

          Could you please post your queries to respective Product(EDC) community ? This community is for Cloud Application Integration Product.

           

          Thanks,

          Prakash Jain

          • 2. Re: Error in ODBC Connection for Data Access in EDC
            Anubhav Srivastava Active Member

            Hi Prakash,

             

            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.

             

            Best Regards,

            Anubhav

            • 3. Re: Error in ODBC Connection for Data Access in EDC
              Nagaraja Ganiga Guru

              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):

               

              export INFA_HOME=/Informatica

              export ODBCHOME=$INFA_HOME/ODBC7.1

              export ODBC_HOME=$ODBCHOME

              export ODBCINST=$ODBCHOME/odbcinst.ini

              export PATH=$ODBCHOME/bin:$PATH

              export LD_LIBRARY_PATH=$ODBCHOME/lib:$LD_LIBRARY_PATH

              export ODBCINI=$ODBCHOME/odbc.ini

               

              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:

              Server@DatabaseName

              Server,Port@DatabaseName

              Server\Instance@DatabaseName

              Server\Instance,Port@DatabaseName

               

              Thanks

              Nagaraja Ganiga

              1 of 1 people found this helpful
              • 4. Re: Error in ODBC Connection for Data Access in EDC
                Markus Auer New Member

                Hello Anubhav,

                 

                if you are not aware please check also the ssgodbc test tool

                https://kb.informatica.com/howto/1/Pages/15339.aspx

                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)

                 

                Driver=<INFA_HOME>/ODBC7.1/lib/DWsqls27.so

                Database=<your_database>

                Hostname=<your_hostname>

                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

                 

                Best regards

                 

                Markus Auer

                • 5. Re: Error in ODBC Connection for Data Access in EDC
                  Madhusoodan Pataki New Member

                  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?

                   

                  Simplest workaround

                  You can manually set the env variables on the shell and reboot the domain in the same shell (session).