Topic
  • 4 replies
  • Latest Post - ‏2013-10-10T12:15:18Z by paul.brett
kk411
kk411
22 Posts

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

    Re: Connection to database failed

    ‏2013-09-26T18:16:25Z  

    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
    22 Posts

    Re: Connection to database failed

    ‏2013-09-30T15:36:54Z  

    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.

    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
  • Jim Divoky
    Jim Divoky
    20 Posts

    Re: Connection to database failed

    ‏2013-10-01T19:47:31Z  
    • kk411
    • ‏2013-09-30T15:36:54Z

    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

    Have you looked at http://ora-12154.ora-code.com/?

     

  • paul.brett
    paul.brett
    516 Posts

    Re: Connection to database failed

    ‏2013-10-10T12:15:18Z  

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