Re: Report question

From: Nestor Florez <Nflorez_at_guhsd.net>
Date: Thu, 03 Jun 2004 10:18:32 -0700
Message-Id: <s0befb14.061@gwia65.guhsd.net>

Muchas Gracias Segnor Reyes,

I actually look at my tnsnames.ora and where you have 'SOAB.WORLD =' I had 'EXTPROC_CONNECTION_DATA =' and I changed to 'orcle10g =' and now it is showing me the database so that I can pick the tables and fields to choose from.

I manage to create my first report, I am dangerous now!!! TNX :-) Néstor Alberto Flórez Torres

>>> jreyes_at_dazasoftware.com 6/3/2004 9:13:20 AM >>>
I think you must read a lot.

In the server You must create a database first, configure the listener and tnsnames.ora and start up.
In the client you must modify the tnsnames.ora to create a conection to the server.
Then you must do a tnsping databasename, and you must get an answer.

For example in tnsnames.ora
SOAB.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))     (CONNECT_DATA = (SID = SOAB))
  )

C:\Documents and Settings\JReyes>tnsping soab.world

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 03-JUN-20
04 12:11:52

Archivos de parßmetros utilizados:
c:\oracle\ora92\network\admin\sqlnet.ora Adaptador TNSNAMES utilizado para resolver el alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192 168.
1.5)(PORT = 1521)) (CONNECT_DATA = (SID = SOAB))) Realizado correctamente (7120 mseg)

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/ 
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html 
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 03 2004 - 12:15:55 CDT