Re: Report question
- From: "Nestor Florez" <Nflorez@xxxxxxxxx>
- To: <jreyes@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 03 Jun 2004 10:18:32 -0700
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@xxxxxxxxxxxxxxxx 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
Copyright (c) 1997 Oracle Corporation. All rights reserved.
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
