Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Distributed Query

Author  Topic 

psychonaut
Starting Member

1 Post

Posted - 2001-07-02 : 05:27:56
I am using distributed queries in my application, against an Oracle 8i db hosted on NT on a different network segment.
Does anyone know of a programmatic way to detect if the target server is available, so that if it isn't, I can automatically reconfigure the linked server to talk to local copies of the data (which I plan to refresh periodically using DTS)?
This seems like a potentially common problem - I wonder if others in this position all change their configurations manually?

Thanks in advance

Mark

   

- Advertisement -