Topic Options
Rate This Topic
#105603 - 11/01/04 10:52 AM Unable to create a View Form
Anonymous
Unregistered


Hello,

I'm trying to create a View form (pg. 138 of 5.1 'Developing AR System Applications: Basic') to a remote Oracle database.
From the command line, a sqlplus query to the database is successful. When using the syntax documented on this page of the guide ('OWNERNAME.TABLENAME@LINK'), an error message is being generated:

A failure during SQL operation to the database:
Failure during SQL operation to the database : ORA-12154: TNS:could not resolve service name ARERR 552

Thanks for your helps!

Top
#105604 - 11/02/04 02:42 PM Re: Unable to create a View Form [Re: Anonymous]
Anonymous
Unregistered


OK, the problem was with the tnsnames.ora on the ARS server.
the DBA guy changed the tnsnames.ora and now I can create my View Form without problems.
cheers

Top
#105605 - 01/12/06 06:17 AM Re: Unable to create a View Form [Re: Anonymous]
Anonymous
Unregistered


Quote:

Hello,

I'm trying to create a View form (pg. 138 of 5.1 'Developing AR System Applications: Basic') to a remote Oracle database.
From the command line, a sqlplus query to the database is successful. When using the syntax documented on this page of the guide ('OWNERNAME.TABLENAME@LINK'), an error message is being generated:

A failure during SQL operation to the database:
Failure during SQL operation to the database : ORA-12154: TNS:could not resolve service name ARERR 552

Thanks for your helps!



Top
#105606 - 02/24/06 09:15 AM Re: Unable to create a View Form [Re: Anonymous]
Anonymous
Unregistered


Hi,

I am attempting to create a remote connection also. I have tested succesfully to the remote dbase also. But i can not connect via a view form.

Is there anything special you needed to do to the ar.cfg file?

I have read all the remedy docs and it still doesn't work yet.

email: rmdyjoe@yahoo.com

Top