Originally posted by: Dan411

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.

Originally posted by: Jim Divoky

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.

Originally posted by: Dan411

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

Originally posted by: Jim Divoky

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

Originally posted by: paul.brett

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