March 16, 2003 at 7:19 pm
When a distributed query is fired , for the first time it gives an error General Network Error and Timedout . When the same query is fired again some times it runs and again throws an error after it runs for some time. Kindly suggest me what to do to over come this problem?
March 18, 2003 at 2:37 am
Have you the rest of the error message which shows the library and protocol used. Has this ever worked? If so what has changed? Is the server behind a firewall? Where are you running the query from? Can that machine ping / connect to the server?
Far away is close at hand in the images of elsewhere.
Anon.
March 18, 2003 at 3:41 am
It doesnot show any library or protocol it used.The server is not behind the fire wall. I am firing the query from the client. From the client machine i am able to ping both the servers. We are making use of the latest MDAC components.Please suggest what needs to be done.
March 18, 2003 at 3:49 am
If your client is connecting to server1 and server1 is doing a distributed query on server2 (linked server) then you need to test connectivity from server1 to server2 (ie ping, EM and QA).
Have you got the latest MDAC on both servers?
Is it 2.7?
Edited by - davidburrows on 03/18/2003 03:50:30 AM
Far away is close at hand in the images of elsewhere.
Anon.
March 18, 2003 at 4:36 am
How do i find the latest MDAC components are installed?
March 18, 2003 at 4:43 am
There are several threads on this site that refer to finding the version of MDAC installed. I use COMCHECK (downloadable from Microsoft).
Have you checked server to server connectivity?
Edited by - davidburrows on 03/18/2003 04:43:18 AM
Far away is close at hand in the images of elsewhere.
Anon.
March 18, 2003 at 4:48 am
Yes i am able to establish connectivity between two servers respectively.
I have checked the version of the MDAC components through registry. MDAC 2.7 version is installed.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply