server to oracle

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,
Pardhasaradhypardha.kolachina@.wipro.com (Pardhasaradhy) wrote in message news:<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

Have you tried connecting directly from the MSSQL server to the Oracle
server using SQLPlus? If that doesn't work, then the linked server
won't work either. If that does work, then you might want to check if
anything has been upgraded or installed recently, eg. if you upgraded
MDAC, then you may need to make registry changes, depending on the
Oracle version:

http://support.microsoft.com/default.aspx?scid=280106
http://support.microsoft.com/default.aspx?kbid=259959

If none of this helps, then perhaps you can give more information -
which MSSQL edition and servicepack, which version of MDAC and the
Oracle client software, which driver (ODBC, MS OLEDB, Oracle OLEDB)
you're using for the linked server etc.

Simon|||Hello,
Thanks for your reply.
The query is executing from SQL Plus and there are no updations on
the server. Following are the details you asked
for

Edition: SQL server 2000 8.00.760 Enterprise Edition
Service pack: SP3
MDAC version: 2.7 SP1
Oracle client s/w: Oracle 8i
I am using MS OLEDB PROVIDER for Oracle to connect to Oracle.

Thanks & Regards,
Pardhasaradhy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!