Re: MS-Query, SQL-NET problem
Date: 1997/05/27
Message-ID: <5mf3f0$ia_at_duke.telepac.pt>#1/1
First, is the view sql equal to the query you are trying?
If both queries you are tying are equal, then I think you can spot the problem if you use our tool, TunaSQL. It can be used in any NT or 95 box, with SQLNet. And then it will explain what Oracle is doing in each SQL (including plans and statistics), so you can spot it easily (I hope. if you don't, then tell me why because we may need to add some something to Tuna).
Fernando Pereira (morgan_at_cardume.com)
CardumeSoftware
www.cardume.com
Tom Haley wrote in article <01bc6534$6b356f20$14a18693_at_thaley.creighton.edu
>...
>Greetings,
>
> I'm not sure if anyone else has had this problem or not, but I am in
need
>of some assistance. I am trying to use MS -Query to connect to an oracle
>database and execute a select query. I don't have any trouble connecting
>to the database or attaching to the oracle tables. The problem occurs
when
>I try to run a query against a "view". When I run the query it either
>takes a very long time to return, or it doesn't come back at all.
>
>If anyone has found a solution to the problem or a work around, please
let
>me know.
>
>Thanks,
>
>Tom Haley
>Information Systems Manager
>Creighton University
>comett_at_creighton.edu
>
>
Received on Tue May 27 1997 - 00:00:00 CEST