Re: Calling a form to access a remote Oracle db.

"Ivan & Natacha Canalejo" <natynavi_at_telocity.com> wrote in message news:Hdr27.1516$h6.312486_at_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.
>
>
>

Use id1/psw1_at_service1 to connect to the database from your form. 8.0.4 has been desupported years ago, please upgrade to 806

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 09 2001 - 23:35:55 CDT