By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

Linked server to oracle

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
pa**************@wipro.com (Pardhasaradhy) wrote in message news:<6b**************************@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
Jul 20 '05 #2

P: n/a
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!
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.