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 -> Linked server to oracle

Linked server to oracle

From: Pardhasaradhy <pardha.kolachina_at_wipro.com>
Date: 19 Jul 2004 23:05:21 -0700
Message-ID: <6be1c03a.0407192205.5b550f82@posting.google.com> 





Hello,


     I have a linked server to oracle 7.1 from SQL 2000. when I try to
execute simple select statement which returns one row of data using
openquery is not fetching the data. After 30 minutes SQL Query
analyser is hanging. This is happening on the production server and it
is working from last 6 months. I have tried by deleting and recreating
the linked server, but no use. Please help



Thanks,



Regards,


Pardhasaradhy
Received on Tue Jul 20 2004 - 01:05:21 CDT












Original text of this message













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