Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't Connect to Oracle8 from Forms4.5

Re: Can't Connect to Oracle8 from Forms4.5

From: Ian <iabramso_at_rci.rogers.com>
Date: 1998/03/06
Message-ID: <01bd4932$1e5dd420$8ae2020a@RELAY32.rogers.com>#1/1

Darren,

        You need to start the SQL*Net listener to solve this problem. You should already have TCP/IP on your machine, if you are connecting to any external sources (even the Internet). You may want to install Net8.         

        So set up listener.ora so that you can connect to your database. Then change tnsnames.ora so that you have a connection string available to use.

        I have to agree that its kind of odd that Forms 4.5 does not recognize the bequeth protocol to Oracle 8. I've had this same problem with all my Oracle products, but I also use Cognos' Impromptu and that product will direct connect to the database without the listener being active.

Ian Abramson
Toronto, ON, Canada

Author of:	Oracle8 Tuning	(Oracle Press)
		Oracle8 Data Warehousing (Oracle Press - coming soon)


Darren Eccles <d.g.e_at_btinternet.com> wrote in article <34FDE2C3.7595EC73_at_btinternet.com>...
> I've tried using SQL*Net 2.3 Easy Config but I always get message
> 'Ora-12545 TNS:name not found'. I assume this means that I have
> enterered the database instance name incorrectly. My init file is called
> initorcl.ora so I should be able to connect to a database instance
> called orcl, but I can't. Or is it possible that there's a problem with
> my TCP/IP. Any ideas?
>
> Thanks in advance
>
> Darren Eccles
>
>
Received on Fri Mar 06 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US