Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2013-10-10T12:15:18Z by paul.brett
kk411
kk411
13 Posts
ACCEPTED ANSWER

Pinned topic Connection to database failed

‏2013-09-25T19:35:02Z |

Hi All

When I  am trying to  connect  to oracle database I am getting error as connection to database failed..I am giving connection string in settings which is  in tns.ora file.I am connecting to Remote server.

Can someone help on this.

 

Thanks in Advance.

 

Updated on 2013-09-25T19:35:18Z at 2013-09-25T19:35:18Z by kk411
  • Jim Divoky
    Jim Divoky
    20 Posts
    ACCEPTED ANSWER

    Re: Connection to database failed

    ‏2013-09-26T18:16:25Z  in response to kk411

    How are you trying to connect? Input card? Output card? DBQUERY function? Turn on the trace file and it should tell you why. You can always post pertinent snippets here.

    • kk411
      kk411
      13 Posts
      ACCEPTED ANSWER

      Re: Connection to database failed

      ‏2013-09-30T15:36:54Z  in response to Jim Divoky

      Hi Jim

      Thanks for your reply.I am trying to create .mdq file.I am getting the following error.

      Error returned by OCIServerAttach, errcode=12154

      ORA-12154: TNS:could not resolve the connect identifier specified

       

      Thanks

      Updated on 2013-10-01T15:56:46Z at 2013-10-01T15:56:46Z by kk411
  • paul.brett
    paul.brett
    452 Posts
    ACCEPTED ANSWER

    Re: Connection to database failed

    ‏2013-10-10T12:15:18Z  in response to kk411

    On what platform do you have this error?

    If you see it in the Database Interface Designer (Windows platform) are you sure you have both the 32 bit and 46 bit Oracle Client libraries loaded?  (WTX Design Studio NEEDS the 32 bit libraries).