Re: Forms 3.0 connect to O7.3.4

Raymond,

you could be right, i have not used two task. but this is how we had to resolve the problem.

we had problems here with the database 7.3 also. Oracle stopped shipping Forms and reports etc on the server cd after release 7.2. You have to install the forms3 reports etc from the 7.1 or 7.2 cd and put them in another
oracle_home like oracle716 but *not* the oracle home you are using for the 7.3
installation.

I have attached a doc from oracle that we where supposed to use. We planned on getting the latest 7.3 server for SCO unix and where told then to install

forms etc from the old server 7.1.6 cd as that was the last release of forms anyway.

If you login in to unix your forms3 and oracle server are on the same server

aren't they ? why are you using a sqlnet connection like scott/tiger_at_TNS:sid. you are
probably using sqlnet v2 which is scott/tiger_at_TNS, without the sid. can you connect using sqlplus using this scott/tiger_at_TNS:sid ?

i'm not sure about getting the forms tables from one database and importing into another its more to do with the actual libs and binaries installed in oracle_home
than the database contents, hence the need for 2 oracle_homes

take a look at the attached doc, it might help.

Noel

-----Original Message-----
From: Tom Sullivan <Tom_Sullivan_at_compuserve.com> To: INTERNET:noel_at_paragon.ie <noel_at_paragon.ie> Date: 17 September 1998 01:54
Subject: Re: Forms 3.0 connect to O7.3.4

Message text written by INTERNET:noel_at_paragon.ie
>Tom,

what op sys are you using ?

Is forms 3 installed on the same server ? or are you trying to connect forms 3 to and oracle database on another server ( ie using sqlnet)

Noel
<

The server is on Sun Solaris (Unix). The clients are on various forms of windows (95,NT,etc.).

Turns out, I can connect to Runform from a client if I specify a connect string in the form scott/tiger_at_TNS:sid. However, I still need to maintain the forms on Unix and generate them in DOS (for windows). For the latter, I understand there is a SQL*Net V2 Lite for DOS. On Unix, I'm not sure what to do as Forms 3.0 isn't on the installation disk for 7.3.4. I guess we'll try exporting the forms/menu related tables from 7.1.6 and import to 7.3.4 and copy the forms executable to the 7.3.4 directories.

Raymond Allo wrote:

> Noel
>
> you have tow set the environment variable TWO_TASK to what is in your
> tnsnames.ora file
> for example
>
> in tnsnames you might have something like
> prd1.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = unixprod)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = unixprod)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = PRD1)
> )
> )
>
> Now you set your environment variable in your profile
> TWO_TASK=prod1
> export TWO_TASK
>
> then run your form runform30 myform etc
>
> Cheers
> Raymond
>
> Noel O'Brien wrote:
>
> > Tom,
> >
> > what op sys are you using ?
> >
> > Is forms 3 installed on the same server ? or are you trying to connect
> > forms 3 to and oracle database on another server ( ie using sqlnet)
> >
> > Noel
> >
> > Tom Sullivan wrote:
> >
> > > I'm getting "ORA-03121 No interface driver connected" trying to
> > > connect sqlforms30 and runform30 to a 7.3.4 database. Anyone know
> > > if/how this is possible?
> > >

> > > TIA
> > >
> > > --
> > > Tom Sullivan
> > > ADI Consulting, Inc.
> > >

> > >

Received on Thu Sep 17 1998 - 09:54:54 CEST