Calling a form to access a remote Oracle db.

From: Ivan & Natacha Canalejo <natynavi_at_telocity.com>
Date: Mon, 9 Jul 2001 19:42:58 -0400
Message-ID: <Hdr27.1516$h6.312486@newsrump.sjc.telocity.net>

I'm using Oracle 8i ver 8.0.4 in windows NT4.0

When I installed both the Developer Forms 6i and Oracle enterprise 8i in the same computer in windows NT 4.0, I can use the runtime forms to execute a compiled form.

The parameters I provided to the form runtime are just: user: id1
password: psw1

In this case Oracle_HOME is the same for both.

My problem is when They are in different computers how can I access the remote database from the client computer where the Developer Forms 6i is installed.

when I use "service1" with SQLPLUS, I can see the remote database, but.

Using these parameters:
user: id1
password: psw1
database: remotecompuer_at_ORCL
service: service1

I can not get a connection is telling me TSN: could not resolve the service.

I've tried diferent combinations for these two parameters but none of then worked.

database: ORCL
service: service1

Is this an installation problem.?
Should I install the form in the server together with the db and call it from the client.?

Can anyone please help me with this.
Thanks.
Ivan. Received on Mon Jul 09 2001 - 18:42:58 CDT