From oracle-l-bounce@freelists.org Thu Jun 3 12:15:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i53HFZ728049 for ; Thu, 3 Jun 2004 12:15:45 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i53HFP627980 for ; Thu, 3 Jun 2004 12:15:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E138C72C128; Thu, 3 Jun 2004 12:01:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26749-60; Thu, 3 Jun 2004 12:01:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F18472C0C8; Thu, 3 Jun 2004 12:01:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 03 Jun 2004 12:00:36 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7D2EA72C03B for ; Thu, 3 Jun 2004 12:00:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26949-09 for ; Thu, 3 Jun 2004 12:00:36 -0500 (EST) Received: from gwia65.guhsd.net (unknown [216.100.215.48]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E323472C025 for ; Thu, 3 Jun 2004 12:00:35 -0500 (EST) Received: from GWDOMAIN-MTA by gwia65.guhsd.net with Novell_GroupWise; Thu, 03 Jun 2004 10:19:00 -0700 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.0 Date: Thu, 03 Jun 2004 10:18:32 -0700 From: "Nestor Florez" To: , Subject: Re: Report question Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1917 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Nflorez@guhsd.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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 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@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@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 -----------------------------------------------------------------