Oracle Form Builder / ORA-12154: TNS : could not resolve the connect identifier specified

Question

I'm getting the error message below when trying to connect to database in the Data Block Wizard (in Oracle Form Builder):

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

In order to fix that, I set the TNS_ADMIN environment variable to the directory path where the tnsnames.ora file exists. In addition, I have changed the tnsnames.ora file content like so:

DEV = (DESCRIPTION =(ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)
          (HOST = localhost)(PORT = 1521)))
          (CONNECT_DATA = (SID = DEV)))

However, I still get the same error message. Any idea how to fix that?

Answer 1

You're trying to base data block on a table that resides in another database, so you're accessing it via a database link. Correct?

If so, create a synonym (that points to that table) in your own schema, and then base data block on that synonym.